Beer Analysis
Abhay Sharma and Derek Rogers
2022-10-07
library(tidyverse)## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.3.6 ✔ purrr 0.3.4
## ✔ tibble 3.1.8 ✔ dplyr 1.0.10
## ✔ tidyr 1.2.0 ✔ stringr 1.4.0
## ✔ readr 2.1.2 ✔ forcats 0.5.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()library(class)
library(caret)## Loading required package: lattice
##
## Attaching package: 'caret'
##
## The following object is masked from 'package:purrr':
##
## liftlibrary(e1071)
library(dplyr)
library(ggthemes)
library(plotly)##
## Attaching package: 'plotly'
##
## The following object is masked from 'package:ggplot2':
##
## last_plot
##
## The following object is masked from 'package:stats':
##
## filter
##
## The following object is masked from 'package:graphics':
##
## layoutlibrary(ggExtra)
library(scales)##
## Attaching package: 'scales'
##
## The following object is masked from 'package:purrr':
##
## discard
##
## The following object is masked from 'package:readr':
##
## col_factorlibrary(scico)
library(stringr)
library(naniar)BeerData = data.frame(read.csv("C:/SMU MS Data Science/DoingDataScience6306/MSDS_6306_Doing-Data-Science/Unit 8 and 9 Case Study 1/Beers.csv"))
BreweriesData = data.frame(read.csv("C:/SMU MS Data Science/DoingDataScience6306/MSDS_6306_Doing-Data-Science/Unit 8 and 9 Case Study 1/Breweries.csv"))
#BeerData = data.frame(read.csv("~/SMU/Term 1/Doing Data Science/MSDS_6306_Doing-Data-Science-Master/Unit 8 and 9 Case Study 1/Beers.csv"))
#BreweriesData = data.frame(read.csv("~/SMU/Term 1/Doing Data Science/MSDS_6306_Doing-Data-Science-Master/Unit 8 and 9 Case Study 1/Breweries.csv"))# Tidy data
#Set state as a factor
BreweriesData$State = as.factor(BreweriesData$State)
BeerData$Style = as.factor(BeerData$Style)
# Remove (year) at the end of the names of beers
BeerData$Name = str_remove(BeerData$Name, "([:space:]|)\\(\\d\\d\\d\\d\\)")
# Remove white space at the start and end of beer names
BeerData$Name = str_trim(BeerData$Name)
#Shows how many duplicates of each beer, 240 unwanted duplicates in total
BeerData %>% count(Name) %>% ungroup() %>% arrange(desc(n))## Name n
## 1 Dale's Pale Ale 14
## 2 Nonstop Hef Hop 12
## 3 Caldera Pale Ale 6
## 4 Oktoberfest 6
## 5 Old Chub 5
## 6 Fat Tire Amber Ale 4
## 7 Longboard Island Lager 4
## 8 Pete's Wicked Summer Brew 4
## 9 Point Nude Beach Summer Wheat 4
## 10 Point Special 4
## 11 1327 Pod's ESB 3
## 12 312 Urban Wheat Ale 3
## 13 Barney Flats Oatmeal Stout 3
## 14 Boont Amber Ale 3
## 15 Boston Lager 3
## 16 Brew Free! or Die IPA 3
## 17 Caldera IPA 3
## 18 Dagger Falls IPA 3
## 19 Double D Blonde 3
## 20 Double Haul IPA 3
## 21 Harpoon IPA 3
## 22 Harpoon Summer Beer 3
## 23 Hell or High Watermelon Wheat 3
## 24 Hop Slayer Double IPA 3
## 25 Montana Trout Slayer Ale 3
## 26 Moose Drool Brown Ale 3
## 27 Point the Way IPA 3
## 28 Ten Fidy Imperial Stout 3
## 29 Wisconsin Amber 3
## 30 #9 2
## 31 312 Urban Pale Ale 2
## 32 483 Pale Ale 2
## 33 Abominable Winter Ale 2
## 34 Alphadelic IPA 2
## 35 Alter Ego 2
## 36 Angry Orchard Crisp Apple 2
## 37 Ashland Amber Ale 2
## 38 Atlantic Amber Ale 2
## 39 Aurora Lager 2
## 40 Beach Blonde 2
## 41 Bengali Tiger 2
## 42 Big Red Coq 2
## 43 Big Sky IPA 2
## 44 Bitter American 2
## 45 Bitter Biker Double IPA 2
## 46 Blacktop Blonde 2
## 47 BLAKKR 2
## 48 Bomber Mountain Amber Ale 2
## 49 Bombshell Blonde 2
## 50 Boxer 2
## 51 British Pale Ale 2
## 52 Brontide 2
## 53 Brooklyn Summer Ale 2
## 54 Buffalo Sweat 2
## 55 CAPT Black IPA 2
## 56 Chaka 2
## 57 Citra Ass Down 2
## 58 Clear Creek Ice 2
## 59 Cold Smoke Scotch Ale 2
## 60 Colorado Native 2
## 61 Colorado Red Ale 2
## 62 Contemplation 2
## 63 Crank Yanker IPA 2
## 64 CuDa Cascadian Dark Ale 2
## 65 Cut Throat Pale Ale 2
## 66 Dank IPA 2
## 67 Deviant Dale's IPA 2
## 68 Devil's Harvest Extra Pale Ale 2
## 69 Devil’s Ale 2
## 70 East India Pale Ale 2
## 71 Epicenter Amber Ale 2
## 72 Evolutionary IPA 2
## 73 Firemans #4 Blonde Ale 2
## 74 Fireside Chat 2
## 75 Firestarter India Pale Ale 2
## 76 Firewater India Pale Ale 2
## 77 Flying Jenny Extra Pale Ale 2
## 78 Full Moon Belgian White Ale 2
## 79 Full Nelson Pale Ale 2
## 80 Golden Road Hefeweizen 2
## 81 Gose 2
## 82 Grapefruit Jungle (GFJ) 2
## 83 Grazias 2
## 84 Great Crescent Blonde Ale 2
## 85 Great Crescent Coconut Porter 2
## 86 Great Crescent IPA 2
## 87 Green Monsta IPA 2
## 88 Habitus 2
## 89 Halcyon Unfiltered Wheat 2
## 90 Hapa Brown Ale 2
## 91 Hazed & Infused 2
## 92 Heady Topper 2
## 93 Hop Ottin' IPA 2
## 94 Hop Shock IPA 2
## 95 Hopworks IPA 2
## 96 Horny Toad Cerveza 2
## 97 Hurricane Amber Ale 2
## 98 Kilt Lifter Scottish-Style Ale 2
## 99 Lake House 2
## 100 Lazy Daze Lager 2
## 101 Le Mort Vivant 2
## 102 Loki Red Ale 2
## 103 Long Hammer IPA 2
## 104 Maduro Brown Ale 2
## 105 Main St. Virginia Ale 2
## 106 Mama's Little Yella Pils 2
## 107 Miner's Gold 2
## 108 Modus Hoperandi 2
## 109 Morning Wood Wheat (Current) 2
## 110 Mountain Crest 2
## 111 Narragansett Summer Ale 2
## 112 Native Amber 2
## 113 Night Cat 2
## 114 Northern Lights India Pale Ale 2
## 115 Oasis 2
## 116 Oberon 2
## 117 Old Grogham Imperial India Pale Ale 2
## 118 One Nut Brown 2
## 119 Osiris Pale Ale 2
## 120 oSKAr the G'Rauch 2
## 121 Our Legacy IPA 2
## 122 Outlaw IPA 2
## 123 Pale Alement 2
## 124 Pine Belt Pale Ale 2
## 125 Plum St. Porter 2
## 126 Point Cascade Pale Ale 2
## 127 Point Oktoberfest 2
## 128 Point Special Lager 2
## 129 Pumpkin Patch Ale 2
## 130 Rail Yard Ale 2
## 131 Ranger IPA 2
## 132 Red Cockaded Ale 2
## 133 Righteous Ale 2
## 134 Roller Dam Red Ale 2
## 135 Rye Porter 2
## 136 Saddle Bronc Brown Ale 2
## 137 SanTan HefeWeizen 2
## 138 Scape Goat Pale Ale 2
## 139 Sex Panther 2
## 140 Shift 2
## 141 Sierra Nevada Pale Ale 2
## 142 Skilak Scottish Ale 2
## 143 Slow Ride 2
## 144 Special Amber 2
## 145 Squatters Full Suspension Pale Ale 2
## 146 Squatters Hop Rising Double IPA 2
## 147 Stout Ol' Friend 2
## 148 Summer Solstice 2
## 149 Sun King Oktoberfest 2
## 150 Sunbru Kölsch 2
## 151 Sunshine Wheat Beer 2
## 152 Suzy B Dirty Blonde Ale 2
## 153 Sweet Action 2
## 154 TailGate Hefeweizen 2
## 155 TailGate IPA 2
## 156 The Brown Note 2
## 157 The Crisp 2
## 158 The Deuce 2
## 159 The Imperial Texan 2
## 160 Torpedo 2
## 161 Trebuchet Double IPA 2
## 162 Tsunami IPA 2
## 163 Undertaker 2
## 164 Undun Blonde Ale 2
## 165 Vanilla Porter 2
## 166 Vivant Tripel 2
## 167 Wachusett Light IPA 2
## 168 Walloon 2
## 169 Wasatch Ghostrider White IPA 2
## 170 Watermelon Ale 2
## 171 Watershed IPA 2
## 172 Wee Muckle 2
## 173 Weisse Versa 2
## 174 White Zombie Ale 2
## 175 Wolf Among Weeds IPA 2
## 176 Wood Splitter Pilsner 2
## 177 Worthy IPA 2
## 178 Zaison 2
## 179 #001 Golden Amber Lager 1
## 180 #002 American I.P.A. 1
## 181 #003 Brown & Robust Porter 1
## 182 #004 Session I.P.A. 1
## 183 077XX 1
## 184 10 Degrees of Separation 1
## 185 10 Ton 1
## 186 113 IPA 1
## 187 11th Hour IPA 1
## 188 12 Man Pale Ale 1
## 189 12th Round 1
## 190 13 Rebels ESB 1
## 191 1335 Wicked Snout 1
## 192 14° ESB 1
## 193 1492 1
## 194 1554 Black Lager 1
## 195 15th Anniversary Abbey Ale 1
## 196 1800 Big Log Wheat 1
## 197 1811 Lager 1
## 198 1836 1
## 199 1881 California Red 1
## 200 1881 California Red Ale 1
## 201 18th Anniversary Gose 1
## 202 1916 Shore Shiver 1
## 203 2012 Black Ale 1
## 204 2014 IPA Cicada Series 1
## 205 2020 IPA 1
## 206 21st Amendment IPA 1
## 207 21st Amendment Watermelon Wheat Beer 1
## 208 3-Way IPA 1
## 209 3 Gear Robust Porter 1
## 210 3 Picket Porter 1
## 211 3 Scrooges 1
## 212 3:33 Black IPA 1
## 213 30 Min Coma 1
## 214 32°/50° Kölsch 1
## 215 33 Select Brown Ale 1
## 216 35 K 1
## 217 360° India Pale Ale 1
## 218 3Beans 1
## 219 40 Mile IPA 1
## 220 4000 Footer IPA 1
## 221 40th Annual Bix Street Fest Copper Ale (Current) 1
## 222 413 Farmhouse Ale 1
## 223 420 Extra Pale Ale 1
## 224 467 Ethan's Stout 1
## 225 4Beans 1
## 226 5 Day IPA 1
## 227 5:00 O'Clock Afternoon Ale 1
## 228 51K IPA 1
## 229 541 American Lager 1
## 230 543 Skull Creek Fresh Hopped Pale Ale 1
## 231 6-4-3 Double Play Pilsner 1
## 232 6 String Saison 1
## 233 668 Neighbor of the Beast (16 oz.) 1
## 234 668 Neighbor of the Beast12 oz. 1
## 235 77 Fremont Select Spring Session IPA 1
## 236 8-Bit Pale Ale 1
## 237 8 Barrel 1
## 238 805 1
## 239 805 Blonde Ale 1
## 240 834 Happy As Ale 1
## 241 98 Problems (Cuz A Hop Ain't One) 1
## 242 A Beer 1
## 243 A Capella Gluten Free Pale Ale 1
## 244 A Little Crazy 1
## 245 A Slice of Hefen 1
## 246 Aaah Bock Lager 1
## 247 AARGHtoberfest! 1
## 248 Abbey's Single (2015- ) 1
## 249 Abbey's Single Ale (Current) 1
## 250 Abigale 1
## 251 Abita Amber 1
## 252 Abominable Ale 1
## 253 Abrasive Ale 1
## 254 Ace Hole American Pale Ale 1
## 255 Ace IPA 1
## 256 Acidulated Trip 1
## 257 Action Man Lager 1
## 258 Adam's Stout 1
## 259 Aftermath Pale Ale 1
## 260 Agave Wheat 1
## 261 Agent a Deux 1
## 262 Akari Shogun American Wheat Ale 1
## 263 Alaskan Amber 1
## 264 Ale Cider 1
## 265 All Aboard! Anniversary Stout 1
## 266 All American Blonde Ale 1
## 267 All American Red Ale 1
## 268 All Day IPA 1
## 269 All Nighter Ale 1
## 270 Alley Time 1
## 271 Alloy 1
## 272 Almanac IPA 1
## 273 Aloha B’ak’tun 1
## 274 Alpha Ale 1
## 275 Alpha Blackback 1
## 276 Alteration 1
## 277 Altus Bohemes Altbier 1
## 278 Amazon Princess IPA 1
## 279 Amber Ale 1
## 280 Amber Road 1
## 281 Ambitious Lager 1
## 282 American Amber 1
## 283 American Hero 1
## 284 American Idiot Ale 1
## 285 American India Red Ale 1
## 286 American Lager 1
## 287 American Light 1
## 288 American Red Porter 1
## 289 American Red Saison 1
## 290 Ananda India Pale Ale 1
## 291 Angry Adam 1
## 292 Angry Orchard Apple Ginger 1
## 293 Annie's Amber Ale 1
## 294 Anti-Hero IPA 1
## 295 Apollo 1
## 296 Appreciation Ale 1
## 297 Aprè Shred 1
## 298 Apricot Blonde 1
## 299 Archer's Ale 1
## 300 Arcus IPA 1
## 301 Are Wheat There Yet? 1
## 302 Arjuna 1
## 303 Arkansas Red 1
## 304 Aslan Amber 1
## 305 Aslan IPA 1
## 306 Aslan Kölsch 1
## 307 Atalanta 1
## 308 Athena 1
## 309 Atom Smasher 1
## 310 Atom Splitter Pale Ale 1
## 311 Atwater's Lager 1
## 312 Aurora 1
## 313 Autocrat Coffee Milk Stout 1
## 314 Autumn Winds 1
## 315 Autumn Winds Fest Beer 1
## 316 Autumnal Molé Stout 1
## 317 Autumnation 1
## 318 Autumnation (2011-12) 1
## 319 Avalanche Ale 1
## 320 Avery India Pale Ale 1
## 321 Avery Joe’s Premium American Pilsner 1
## 322 Aviator Raspberry Blonde 1
## 323 Awry Rye Pale Ale 1
## 324 Axe Head Malt Liquor 1
## 325 AXL Pale Ale 1
## 326 B3K Black Lager 1
## 327 Babbling Blonde 1
## 328 Baby Daddy Session IPA 1
## 329 Back Bay IPA 1
## 330 Back Country Scottish Ale 1
## 331 Back East Ale 1
## 332 Back East Golden Ale 1
## 333 Back East Porter 1
## 334 Back in Black 1
## 335 Back in the Saddle Rye Pale Ale 1
## 336 Backyahd IPA 1
## 337 Bacon Brown Ale 1
## 338 Bad Axe Imperial IPA 1
## 339 Ball & Chain 1
## 340 Ballast Point Pale Ale 1
## 341 Ballistic Blonde 1
## 342 Ballz Deep Double IPA 1
## 343 Balt Altbier 1
## 344 Baltic Porter 1
## 345 Banner American Ale 1
## 346 Banner American Rye 1
## 347 Bark Bite IPA 1
## 348 Barn Burner Saison 1
## 349 Barn Yeti 1
## 350 Barrel Aged Farmer 1
## 351 Barrel Aged Seven Devils Imperial Stout 1
## 352 Barrel Aged Triomphe 1
## 353 Barrio Blanco 1
## 354 Barrio Tucson Blonde 1
## 355 Barstool American Golden Ale 1
## 356 Bastian 1
## 357 Bat Outta Helles 1
## 358 Batch 69 IPA 1
## 359 Battle LIne 1
## 360 Bay of Bengal Double IPA 1
## 361 Be Hoppy IPA 1
## 362 Beach Cruiser 1
## 363 Beach Patrol 1
## 364 Bear Ass Brown 1
## 365 Bear Butte Nut Brown Ale 1
## 366 Beasts A'Burnin' 1
## 367 Beaver Logger 1
## 368 Becky's Black Cat Porter 1
## 369 Beelzebub 1
## 370 Beer Agent Re-Ignition 1
## 371 Behemoth 1
## 372 Belfort 1
## 373 Belgian Style Session Ale 1
## 374 Belgian Wit 1
## 375 Belgorado 1
## 376 Bellingham Beer Week 2013 Collaboration 1
## 377 Beltian White 1
## 378 Bender 1
## 379 Bengali 1
## 380 Bent Hop Golden IPA 1
## 381 Bent Paddle Black Ale 1
## 382 Berliner Weisse 1
## 383 Bermuda Triangle Ginger Beer 1
## 384 Best Brown 1
## 385 Better Half 1
## 386 Better Weather IPA 1
## 387 Beyond The Pale IPA 1
## 388 Big Bend Hefeweizen 1
## 389 Big Blue Van 1
## 390 Big Bowl Blonde Ale 1
## 391 Big Chuck Barleywine 1
## 392 Big Cock IPA 1
## 393 Big Elm IPA 1
## 394 Big Eye India Pale Ale 1
## 395 Big Island Shandy 1
## 396 Big Nose 1
## 397 Big River Pilsner 1
## 398 Big Rod Coconut Ale 1
## 399 Big Star White IPA 1
## 400 Big Swell IPA 1
## 401 Bikini Beer 1
## 402 Bikini Blonde Lager 1
## 403 Bimini Twist 1
## 404 Birdhouse Pale Ale 1
## 405 Birth IPA 1
## 406 Bitter Bitch 1
## 407 Bitter Bitch Imperial IPA 1
## 408 Bitter Brewer 1
## 409 Black 1
## 410 Black Adder IBA (Current) 1
## 411 Black Bay Milk Stout 1
## 412 Black Bear Dark Lager 1
## 413 Black Beer'd 1
## 414 Black Exodus 1
## 415 Black Hop IPA 1
## 416 Black House 1
## 417 Black IPA 1
## 418 Black Iron India Pale Ale 1
## 419 Black Market Hefeweizen 1
## 420 Black Me Stout 1
## 421 Black Noddy Lager (Current) 1
## 422 Black Rabbit 1
## 423 Black Raspberry Nectar 1
## 424 Black Star Double Hopped Golden Lager (12 oz.) 1
## 425 Black Star Double Hopped Golden Lager (24 oz.) 1
## 426 Black Thunder 1
## 427 Black Walnut Wheat 1
## 428 Blackbeard 1
## 429 Blackbeary Wheat 1
## 430 Blackberry Wheat 1
## 431 Blackmarket Rye IPA 1
## 432 Blazing World 1
## 433 Bleeding Buckeye Red Ale 1
## 434 Block Party Robust Porter 1
## 435 Blonde Czich 1
## 436 Blonde Hunny 1
## 437 Blood of the Unicorn 1
## 438 Blood Orange Gose 1
## 439 Blood Orange Honey 1
## 440 Blood Orange Saison 1
## 441 Blood Orange Wit 1
## 442 Bloody Show 1
## 443 Blown Out Brown 1
## 444 Blue Boots IPA 1
## 445 Blue Gold 1
## 446 Blue Mountain Classic Lager 1
## 447 Blue Paddle 1
## 448 Blue Point Summer Ale 1
## 449 Blue Point White IPA 1
## 450 Blueberry Berliner Weisse 1
## 451 Blueberry Blonde 1
## 452 Blueberry Blonde Ale 1
## 453 Blur India Pale Ale 1
## 454 Boat Beer 1
## 455 Boater Beer 1
## 456 Boathouse Blonde 1
## 457 Bobblehead 1
## 458 Bodacious Bock 1
## 459 Bohemian Export Lager 1
## 460 Bohemian Pils 1
## 461 Boise Co-Op Two Score Ale 1
## 462 Boji Beach Golden Rye Ale 1
## 463 Boji Blue Pale Ale 1
## 464 Bomb Lager (New Recipe) 1
## 465 Bomb Lager (Old Recipe) 1
## 466 Boneshaker Brown Ale 1
## 467 Boohai Red Ale 1
## 468 Booming Rollers 1
## 469 Booyah Farmhouse Ale 1
## 470 Bottom Up Belgian Wit 1
## 471 Bourbon's Barrel Stout 1
## 472 Bourbon Barrel Aged Coconut Porter 1
## 473 Bourbon Barrel Aged Timmie 1
## 474 Bourbon Barrel Batch 666: Sympathy for the Devil 1
## 475 Bourbon Barrel Cowbell 1
## 476 Bourbon Barrel Johan 1
## 477 Bourbon Barrel Wee Mac 1
## 478 Boxer Ice 1
## 479 Boxer Light 1
## 480 Boy King 1
## 481 Bozone Hefe Weizen 1
## 482 Bozone HopZone IPA 1
## 483 Bozone Select Amber Ale 1
## 484 Brass Knuckle Pale Ale 1
## 485 Bravo Four Point 1
## 486 Brewerhood Brown Ale 1
## 487 BrewFarm Select Golden Lager 1
## 488 Bridal Veil Rye Pale Ale 1
## 489 BrightCider 1
## 490 BRIK Irish Red Ale 1
## 491 Bring Back the Beach Blonde Ale 1
## 492 BRIPA 1
## 493 Broad Brook Ale 1
## 494 Broken Bridge 1
## 495 Bronx Black Pale Ale 1
## 496 Bronx Pale Ale 1
## 497 Bronx Summer Pale Ale 1
## 498 Brooklyn Lager (12 oz.) 1
## 499 Brooklyn Lager (16 oz.) 1
## 500 Brotherhood Steam 1
## 501 Brownstone 1
## 502 Brünette 1
## 503 Brunette Nut Brown Ale 1
## 504 Brush Creek Blonde 1
## 505 Brutus 1
## 506 Buck Snort Stout 1
## 507 Bunker Hill Blueberry Ale 1
## 508 Buried Hatchet Stout 1
## 509 Burning Bush Smoked IPA 1
## 510 Bushwhacker Cider 1
## 511 Cabrillo Kölsch 1
## 512 Cache La Porter 1
## 513 Cack-A-Lacky 1
## 514 Cafe Leche 1
## 515 Cal and Co. Black Cherry Porter 1
## 516 Cali Creamin' 1
## 517 California Lager 1
## 518 California Route 1
## 519 California Sunshine Rye IPA 1
## 520 Calyptra 1
## 521 Camelback 1
## 522 Campside Session IPA 1
## 523 CAN'D AID Foundation 1
## 524 Cane and Ebel 1
## 525 CANfusion Rye Bock 1
## 526 Cant Dog Imperial Pale Ale 1
## 527 Canyon Cream Ale 1
## 528 Cape Cod Red 1
## 529 Capital Gold Golden Lager 1
## 530 Capital Trail Pale Ale 1
## 531 Captain's Daughter 1
## 532 Car 21 1
## 533 Cardinal Pale Ale 1
## 534 Carolina Blonde 1
## 535 Carolina Blonde Light 1
## 536 Carolina Lighthouse 1
## 537 Cascadian Dark Ale 1
## 538 Casinos IPA 1
## 539 Casper White Stout 1
## 540 Cast Iron Oatmeal Brown 1
## 541 Catch 23 1
## 542 Category 3 IPA 1
## 543 Cavatica Stout 1
## 544 Cedar Point 1
## 545 Celestial Blonde Ale 1
## 546 Celestial Meridian Cascadian Dark Lager 1
## 547 Celsius Summer Ale 1
## 548 Centennial IPA 1
## 549 Centennial State Pale Ale 1
## 550 CEO Stout 1
## 551 Chai Ale 1
## 552 Chaotic Double IPA 1
## 553 Charlie's Rye IPA 1
## 554 Charlie in the Rye 1
## 555 Cherny Bock 1
## 556 Cherried Away 1
## 557 Cherry Ale 1
## 558 Cherry Ale (1) 1
## 559 Cherry Bomb 1
## 560 Cherry Doppelbock 1
## 561 Chester's Beer 1
## 562 Chickawawa Lemonale 1
## 563 Chin Music Amber Lager 1
## 564 Choc Beer 1
## 565 Chomolungma Honey Nut Brown Ale 1
## 566 Christmas Ale 1
## 567 Chronic Ale 1
## 568 Chugach Session Ale 1
## 569 Chuli Stout 1
## 570 Chupahopra 1
## 571 Churchkey Pilsner Style Beer 1
## 572 Circuit Bohemian Pilsner 1
## 573 Citra Faced 1
## 574 Citrafest 1
## 575 City of the Sun 1
## 576 Clan Warrior 1
## 577 Claritas 1
## 578 Classique 1
## 579 Clean Shave IPA 1
## 580 Clem's Gold 1
## 581 Cleveland Beer Week 2013 1
## 582 Coconoats 1
## 583 Coconut Brown Ale 1
## 584 CoCoNut Porter 1
## 585 Coffee Bender 1
## 586 Coffee Oatmeal Stout 1
## 587 Cold Press 1
## 588 Cold Snap 1
## 589 Colette 1
## 590 Colorado Kölsch 1
## 591 Colorojo Imperial Red Ale 1
## 592 Common Sense Kentucky Common Ale 1
## 593 Commotion APA 1
## 594 Cone Crusher 1
## 595 Consilium 1
## 596 Contact High 1
## 597 Copper Hook 1
## 598 Copperhead Amber 1
## 599 Coq D'Or 1
## 600 Coq de la Marche 1
## 601 Core ESB 1
## 602 Core Oatmeal Stout 1
## 603 Cornerstone IPA 1
## 604 Cornstalker Dark Wheat 1
## 605 Cortez Gold 1
## 606 Cotton Mouth 1
## 607 Couch Select Lager 1
## 608 Cougar 1
## 609 Count Hopula (Vault Series) 1
## 610 Country Boy IPA 1
## 611 Country Pale Ale 1
## 612 County Line IPA 1
## 613 Cow Creek 1
## 614 Cowbell 1
## 615 Crabtree Oatmeal Stout 1
## 616 Cranberry Blend 1
## 617 Crazy Mountain Amber Ale 1
## 618 Cream Ale 1
## 619 Cropduster Mid-American IPA 1
## 620 Csar 1
## 621 Cubano Espresso 1
## 622 Curious Traveler Shandy 1
## 623 Cutthroat Pale Ale 1
## 624 CynicAle 1
## 625 Czech Pilsner 1
## 626 Czech Yo Self 1
## 627 Dad 1
## 628 Daft Funk 1
## 629 Daisy Cutter Pale Ale 1
## 630 Dale's Pale Ale (10 Year Anniversary) 1
## 631 Dallas Blonde 1
## 632 Dam Lager 1
## 633 Damascene Apricot Sour 1
## 634 Dammit Jim! 1
## 635 Damnesia 1
## 636 Dankosaurus 1
## 637 Dark Star 1
## 638 Dark Voyage Black IPA 1
## 639 Davy Jones Lager 1
## 640 DAX Light 1
## 641 Day Break 4-Grain Breakfast Beer 1
## 642 Day Hike Session 1
## 643 Day Tripper Pale Ale 1
## 644 Dayman IPA 1
## 645 Dead-Eye DIPA 1
## 646 Dead Arm 1
## 647 Dead Armadillo Amber Ale 1
## 648 Dead Eye Dunkel 1
## 649 Dead Horse Amber 1
## 650 Deadeye Jack 1
## 651 Deadicated Amber 1
## 652 Deception 1
## 653 Deduction 1
## 654 Deep Ellum IPA 1
## 655 Deep Ellum Pale Ale 1
## 656 Deflator 1
## 657 Demshitz Brown Ale 1
## 658 Denver Pale Ale (Artist Series No. 1) 1
## 659 Des Moines IPA 1
## 660 Descender IPA 1
## 661 Desert Magic IPA 1
## 662 Desolation IPA 1
## 663 Devastator Double Bock 1
## 664 Devil's Cup 1
## 665 Devils Head Red Ale 1
## 666 Devils Tramping Ground Tripel 1
## 667 Diesel 1
## 668 Dirtbag Dunkel 1
## 669 Dirty Bastard 1
## 670 Dirty Blonde Ale 1
## 671 Dirty Blonde Chocolate Ale 1
## 672 Dirty Hippie Dark Wheat 1
## 673 Disco Superfly 1
## 674 Disconnected Red 1
## 675 Divided Sky 1
## 676 Dock Street Amber Beer 1
## 677 Dodgy Knight Imperial IPA 1
## 678 Dog Days Lager 1
## 679 Dog Days Summer Ale 1
## 680 Dolores River Dry Stout 1
## 681 Dolores River ESB 1
## 682 Dolores River Hefeweizen 1
## 683 Dolores River Mild 1
## 684 Dolores River Pale Ale 1
## 685 Doomtree 1
## 686 Dos Pistolas 1
## 687 Dottie Seattle Lager 1
## 688 Double Bag 1
## 689 Double Brown Stout 1
## 690 Double Dagger Imperial IPA 1
## 691 Double Duckpin 1
## 692 Double Play Pilsner 1
## 693 Double Trunk 1
## 694 Dragonfly IPA 1
## 695 Draught Hard Apple Cider 1
## 696 Dread Brown Ale 1
## 697 Dream Crusher Double IPA 1
## 698 Dreamin' Double IPA 1
## 699 Driftwood Ale 1
## 700 Drop Dead Blonde 1
## 701 Drop Kick Ale 1
## 702 Dry-Hopped On The High Seas Caribbean-Style IPA 1
## 703 Dry Cider 1
## 704 Dry Dock Amber Ale 1
## 705 Dry Dock Hefeweizen 1
## 706 Dry Hard Apple Cider 1
## 707 Dry Hard Cider 1
## 708 Dry Heat Hefeweizen 1
## 709 Dubbelicious 1
## 710 Duckpin Pale Ale 1
## 711 Duke's Cold Nose Brown Ale 1
## 712 Duluchan India Pale Ale 1
## 713 Dundee Summer Wheat Beer 1
## 714 Dunkel Lager 1
## 715 Dusty Trail Pale Ale 1
## 716 Earth-Like Planets 1
## 717 Easy Day Kolsch 1
## 718 Easy Jack 1
## 719 Easy Livin' Summer Ale 1
## 720 Eclipse Black IPA 1
## 721 Eddy Out Pale Ale 1
## 722 Edward’s Portly Brown 1
## 723 El Chingon IPA 1
## 724 El Conquistador Extra Pale Ale 1
## 725 El Hefe Speaks 1
## 726 El Rojo 1
## 727 El Steinber Dark Lager 1
## 728 Elder Betty 1
## 729 Element 29 1
## 730 Elephant Rock IPA 1
## 731 Elevated IPA 1
## 732 Elevation Triple India Pale Ale 1
## 733 Ellie’s Brown Ale 1
## 734 Elliott's Phoned Home Pale Ale 1
## 735 Elm City Lager 1
## 736 Elm City Pilsner 1
## 737 En Parfaite Harmonie 1
## 738 Endless Summer Ale 1
## 739 Endless Sun Ale 1
## 740 Englishman 1
## 741 Enlighten 1
## 742 EOS Hefeweizen 1
## 743 Epic IPA 1
## 744 Epitome 1
## 745 Ermal's 1
## 746 ESB Special Ale 1
## 747 Escape to Colorado 1
## 748 Escoffier Bretta Ale 1
## 749 Estival Cream Stout 1
## 750 Ethos IPA 1
## 751 Eugene Porter 1
## 752 Euphoria Pale Ale 1
## 753 Even Keel 1
## 754 Evil Owl 1
## 755 Evo IPA 1
## 756 Ex Umbris Rye Imperial Stout 1
## 757 Excess IPL 1
## 758 Extra Pale Ale 1
## 759 F5 IPA 1
## 760 Face Down Brown Ale 1
## 761 Face Plant IPA 1
## 762 Fairweather IPA 1
## 763 Fall Hornin' 1
## 764 Falling Down Brown Ale 1
## 765 Farm Girl Saison 1
## 766 Farm Hand 1
## 767 Farmer's Daughter Blonde 1
## 768 Farmer's Daughter Wheat 1
## 769 Farmer's Tan Red Ale 1
## 770 Farmer Brown Ale 1
## 771 Farmer John's Multi-Grain Ale 1
## 772 Farmer Ted's Cream Ale 1
## 773 Farmer Ted's Farmhouse Cream Ale 1
## 774 Farmer Wirtz India Pale Ale 1
## 775 Farmhouse Wit 1
## 776 Fascist Pig Ale 1
## 777 Fat Badger 1
## 778 Fat Paczki 1
## 779 Father's Beer 1
## 780 Fear of a Brett Planet 1
## 781 Fearless Scottish Ale 1
## 782 Feel Like Maplin' Love 1
## 783 Fenway American Pale Ale 1
## 784 Ferus Fluxus Wild Belgian Pale Ale 1
## 785 Festeroo Winter Ale 1
## 786 Festie 1
## 787 Festivus (1) 1
## 788 Field 41 Pale Ale 1
## 789 Filthy Hoppin' IPA 1
## 790 Fire Eagle IPA 1
## 791 Firefly Amber Ale 1
## 792 First Press 1
## 793 First Stand 1
## 794 Fisherman's Brew 1
## 795 Fisherman's IPA 1
## 796 Fisherman's Pils 1
## 797 Fist City 1
## 798 Fistful Of Hops Blue 1
## 799 Fistful of Hops Green 1
## 800 Fistful of Hops Orange 1
## 801 Fistful Of Hops Red 1
## 802 Fistmas Ale 1
## 803 Fivepine Chocolate Porter 1
## 804 Flagship Ale 1
## 805 Flagship IPA 1
## 806 Flaming Damsel Lager 1
## 807 Flesh Gourd'n 1
## 808 Float Trip Ale 1
## 809 Floppin' Crappie 1
## 810 Florida Cracker Belgian Wit 1
## 811 Flower Child 1
## 812 Floyd's Folly 1
## 813 Flyin' HI.P.Hay 1
## 814 Flyin' Rye 1
## 815 Flying Mouse 4 1
## 816 Flying Mouse 8 1
## 817 Flying Sailor 1
## 818 FMB 101 1
## 819 Focal Banger 1
## 820 Foreman 1
## 821 Forest Fire Imperial Smoked Rye 1
## 822 Fort Pitt Ale 1
## 823 Fortunate Islands 1
## 824 Four Peaks Peach Ale 1
## 825 Four Squared 1
## 826 Four String Vanilla Porter 1
## 827 Fox Tail Gluten Free Ale 1
## 828 Frankenlou's IPA 1
## 829 Franz 1
## 830 Freedom Fries 1
## 831 Freeride APA 1
## 832 Freestyle Pilsner 1
## 833 Fremont Organic Pale Ale 1
## 834 Fremont Summer Ale 1
## 835 Fresh Cut Pilsner 1
## 836 Fresh Slice White IPA 1
## 837 Frosted Fields Winter Wheat 1
## 838 Full Boar Scotch Ale 1
## 839 Furious 1
## 840 G'KNIGHT 1
## 841 G'KNIGHT (12 oz.) 1
## 842 G'KNIGHT (16 oz.) 1
## 843 G. B. Russo’s Italian Pistachio Pale Ale 1
## 844 Galaxy High 1
## 845 Galaxy IPA 1
## 846 Galaxyfest 1
## 847 Galena Golden 1
## 848 Gandhi-Bot Double IPA (12 oz.) 1
## 849 Gandhi-Bot Double IPA (16 oz.) 1
## 850 Gangway IPA 1
## 851 Gansett Light 1
## 852 Garce Selé 1
## 853 Gatecrasher 1
## 854 Gateway Kolsch Style Ale 1
## 855 Gator Tail Brown Ale 1
## 856 Geary's Pale Ale 1
## 857 Geary's Summer Ale 1
## 858 General George Patton Pilsner 1
## 859 Gerry Dog Stout 1
## 860 Get Together 1
## 861 Get Up Offa That Brown 1
## 862 Getaway 1
## 863 Ghose Drifter Pale Ale 1
## 864 Ghost Bike Pale Ale 1
## 865 Ghost Rider Pale Ale 1
## 866 Ghost Ship White IPA 1
## 867 Giant DIPA 1
## 868 Gillespie Brown Ale 1
## 869 Ginger Cider 1
## 870 Ginger Peach 1
## 871 Ginger Peach Saison 1
## 872 Ginja Ninja 1
## 873 Global Warmer 1
## 874 Gnarly Brown 1
## 875 God Damn Pigeon Porter 1
## 876 Gold 1
## 877 Golden Fleece 1
## 878 Golden Frau Honey Wheat 1
## 879 Golden One 1
## 880 Golden Pilsner 1
## 881 Golden Ratio IPA 1
## 882 Golden State Ale 1
## 883 Golden Trout Pilsner 1
## 884 Golden Wing Blonde Ale 1
## 885 Gone A-Rye 1
## 886 Good People American Brown Ale 1
## 887 Good People IPA 1
## 888 Good People Pale Ale 1
## 889 Good Vibes IPA 1
## 890 Goose Island India Pale Ale 1
## 891 Gordon 1
## 892 Gordon Ale 1
## 893 Gordon Beer 1
## 894 Gordon Imperial Red 1
## 895 Gossamer Golden Ale 1
## 896 Graham Cracker Porter 1
## 897 Gran Met 1
## 898 Gran Sport 1
## 899 Grand Canyon American Pilsner 1
## 900 Grand Canyon Sunset Amber Ale 1
## 901 Grand Circus IPA 1
## 902 Grand Rabbits 1
## 903 Grand Trunk Bohemian Pils 1
## 904 Grandma's Pecan 1
## 905 Granny Smith Hard Apple Cider 1
## 906 Grapefruit IPA 1
## 907 Grapefruit Sculpin 1
## 908 Grateful White 1
## 909 Great Crescent Belgian Style Wit 1
## 910 Great Crescent Brown Ale 1
## 911 Great Crescent Dark Lager 1
## 912 Great Crescent Mild Ale 1
## 913 Great Crescent Oktoberfest Lager 1
## 914 Great Crescent Stout 1
## 915 Great Falls Select Pale Ale 1
## 916 Great River Golden Ale 1
## 917 Green Bullet Organic India Pale Ale 1
## 918 Green Collar 1
## 919 Green Head IPA 1
## 920 Green House India Pale Ale 1
## 921 Greenbelt Farmhouse Ale 1
## 922 Greenville Pale Ale 1
## 923 Greenwood Beach 1
## 924 Grey Lady 1
## 925 GreyBeardâ„¢ IPA 1
## 926 Grind Line 1
## 927 Grisette 1
## 928 Groupe G 1
## 929 GUBNA Imperial IPA 1
## 930 Guest Lager 1
## 931 Gunga Din 1
## 932 Gutch English Style Mild Ale 1
## 933 Gwar Beer 1
## 934 Gyptoberfest 1
## 935 Habitus IPA 1
## 936 Hala Kahiki Pineapple Beer 1
## 937 Hale's Pale American Ale 1
## 938 Half Court IPA 1
## 939 Half Cycle IPA 1
## 940 Half Full Bright Ale 1
## 941 Hammer & Sickle 1
## 942 Hangar 24 Helles Lager 1
## 943 Hans' Pils 1
## 944 Happening Now 1
## 945 Happy Amber 1
## 946 Happy Camper IPA 1
## 947 Happy Cider 1
## 948 Harbinger 1
## 949 Hard Apple 1
## 950 Hard Cider 1
## 951 Hardcore Chimera 1
## 952 Hardywood Cream Ale 1
## 953 Harness the Winter 1
## 954 Harpoon Octoberfest 1
## 955 Harvest Ale 1
## 956 Hat Trick Hop IPA 1
## 957 Havanüther 1
## 958 Hawaiian Crow Porter 1
## 959 Hayride Autumn Ale 1
## 960 Haywire Hefeweizen 1
## 961 Hazy Day Belgian-Style Wit 1
## 962 He Said Baltic-Style Porter 1
## 963 He Said Belgian-Style Tripel 1
## 964 Headless Wylie 1
## 965 Heal the Bay IPA 1
## 966 Healani 1
## 967 Heavy Lifting 1
## 968 Heavy Machinery IPA Series #1: Heavy Fist 1
## 969 Hefe Black 1
## 970 Hefe Lemon 1
## 971 Heiner Brau Kölsch 1
## 972 Heinnieweisse Weissebier 1
## 973 Helen's Blend 1
## 974 Heliocentric Hefeweizen 1
## 975 Helios Hefeweizen 1
## 976 Hell 1
## 977 Hell-Diver Pale Ale 1
## 978 Helles Golden Lager 1
## 979 Hemlock Double IPA 1
## 980 Here Gose Nothin' 1
## 981 Heyoka IPA 1
## 982 HGH (Home Grown Hops): Part Duh 1
## 983 Hi-Res 1
## 984 Hibernal Vinifera Stout 1
## 985 Hibernation Ale 1
## 986 Hideout Helles 1
## 987 High Country Pilsner (Current) 1
## 988 Hijack 1
## 989 Hill 88 Double IPA 1
## 990 Hilliard's Amber Ale 1
## 991 Hilliard's Blonde 1
## 992 Hilliard's Pils 1
## 993 Hilliard's Saison 1
## 994 Hinchtown Hammer Down 1
## 995 Hips Don't Lie 1
## 996 Hipster Ale (Two Roads Brewing) 1
## 997 Hipster Ale (Westbrook Brewing) 1
## 998 Hipster Breakfast 1
## 999 Hobnob B & B Pale Ale 1
## 1000 Hodad Porter 1
## 1001 Hog Wild India Pale Ale 1
## 1002 Homefront IPA 1
## 1003 Honey Badger Blonde 1
## 1004 Honey Cider 1
## 1005 Honey Kolsch 1
## 1006 Honey Lav 1
## 1007 Honey Rye 1
## 1008 Honey Wheat 1
## 1009 Honeyspot Road White IPA 1
## 1010 Hoodoo Voodoo IPA 1
## 1011 Hoopla Pale Ale 1
## 1012 Hop A-Peel 1
## 1013 Hop A Potamus Double Dark Rye Pale Ale 1
## 1014 Hop Abomination 1
## 1015 Hop Bomber Rye Pale Ale 1
## 1016 Hop Box Imperial IPA 1
## 1017 Hop Crisis 1
## 1018 Hop Drop 'N Roll IPA 1
## 1019 Hop Farm IPA 1
## 1020 Hop Freak 1
## 1021 Hop Happy 1
## 1022 Hop in the ‘Pool Helles 1
## 1023 Hop Knot IPA 1
## 1024 Hop Lace 1
## 1025 Hop Nosh IPA 1
## 1026 Hop Notch IPA 1
## 1027 Hop Ryot 1
## 1028 Hop Session 1
## 1029 Hop Stalker Fresh Hop IPA 1
## 1030 Hop Syndrome 1
## 1031 Hop Up Offa That Brett 1
## 1032 Hopadillo India Pale Ale 1
## 1033 Hopalicious 1
## 1034 HopArt 1
## 1035 Hoperation Overload 1
## 1036 Hopitoulas IPA 1
## 1037 Hopkick Dropkick 1
## 1038 Hopluia 1
## 1039 Hopnoxious Imperial IPA 1
## 1040 Hoponius Union 1
## 1041 Hopped on the High Seas (Ahtanum) 1
## 1042 Hopped on the High Seas (Calypso) 1
## 1043 Hopped on the High Seas (Citra) 1
## 1044 Hopped on the High Seas (Hop #529) 1
## 1045 Hopportunity Knocks IPA 1
## 1046 Hoppy Bitch IPA 1
## 1047 Hoppy Boy 1
## 1048 Hopsmith Pale Lager 1
## 1049 Hoptopus Double IPA 1
## 1050 Hopvale Organic Ale 1
## 1051 Horny Monk 1
## 1052 Hot Date Ale 1
## 1053 Hot Rod Red 1
## 1054 Hotbox Brown 1
## 1055 Hotter Than Helles Lager 1
## 1056 House Brand IPA 1
## 1057 House Lager 1
## 1058 HUB Lager 1
## 1059 Huber 1
## 1060 Huber Bock 1
## 1061 Hubris Quadrupel Anniversary Ale 1
## 1062 Hula Hoppie Session IPA 1
## 1063 Humbucker Helles 1
## 1064 Humidor Series India Pale Ale 1
## 1065 Humpback Blonde Ale 1
## 1066 Humulus Nimbus Super Pale Ale 1
## 1067 Hunny Do Wheat 1
## 1068 Hustle 1
## 1069 Hydraulion Red 1
## 1070 Hyzer Flip 1
## 1071 I-10 IPA 1
## 1072 I.P. Eh! 1
## 1073 I.W.A. 1
## 1074 Ice Pick Ale 1
## 1075 Icey.P.A. 1
## 1076 Immersion Amber 1
## 1077 Immersion Amber Ale 1
## 1078 Imperial Java Stout 1
## 1079 Imperial Pumpkin Stout 1
## 1080 In-Tents India Pale Lager 1
## 1081 In the Weeds 1
## 1082 Inclined Plane Ale 1
## 1083 Incredible Pedal IPA 1
## 1084 Independence Pass Ale 1
## 1085 India Pale Ale 1
## 1086 Indian Paintbrush IPA 1
## 1087 Indianapolis Indians Lager 1
## 1088 Indians Victory Lager 1
## 1089 Indie Pale Ale 1
## 1090 Infamous IPA 1
## 1091 Initial Point India Pale Ale 1
## 1092 Insert Hop Reference 1
## 1093 Interurban IPA 1
## 1094 Invasion Pale Ale 1
## 1095 IPA 1
## 1096 IPA #11 1
## 1097 IPA & a Half 1
## 1098 Irish Channel Stout 1
## 1099 Iron Butt Red Ale 1
## 1100 Iron Horse Pale Ale 1
## 1101 Iron Mike Pale Ale 1
## 1102 Ironman 1
## 1103 Irregardless IPA 1
## 1104 Isis 1
## 1105 Island Wheat 1
## 1106 Jacaranada Rye IPA 1
## 1107 Jack's Hard Cider 1
## 1108 Jack Pine Savage 1
## 1109 Jack Stout 1
## 1110 Jack the Sipper 1
## 1111 Jade 1
## 1112 Jah Mon 1
## 1113 Jai Alai IPA 1
## 1114 Jai Alai IPA Aged on White Oak 1
## 1115 Jalapeno Pale Ale 1
## 1116 Jam Session 1
## 1117 Jammer 1
## 1118 Java Mac 1
## 1119 Java the Hop 1
## 1120 Jessie's Garage 1
## 1121 Jockamo IPA 1
## 1122 Joey Wheat 1
## 1123 Johan the Barleywine 1
## 1124 Johnny's American IPA 1
## 1125 Jon Boat Coastal Ale 1
## 1126 José Martà American Porter 1
## 1127 Joseph James American Lager 1
## 1128 JP's Ould Sod Irish Red IPA 1
## 1129 Jucundus 1
## 1130 Juke Joint IPA 1
## 1131 Just IPA 1
## 1132 Kadigan 1
## 1133 Kaleidoscope Collaboration 2012 1
## 1134 Kamen Knuddeln 1
## 1135 Karbachtoberfest 1
## 1136 Kaua'i Golden Ale 1
## 1137 Keebarlin' Pale Ale 1
## 1138 Keeper (Current) 1
## 1139 KelSo India Pale Ale 1
## 1140 KelSo Nut Brown Lager 1
## 1141 KelSo Pilsner 1
## 1142 Kentucky IPA 1
## 1143 Kentucky Kölsch 1
## 1144 Killer Kolsch 1
## 1145 Killer Whale Cream Ale 1
## 1146 Kilt Dropper Scotch Ale 1
## 1147 Kindler Pale Ale 1
## 1148 King Coconut 1
## 1149 King Street Blonde Ale 1
## 1150 King Street Hefeweizen 1
## 1151 King Street IPA 1
## 1152 King Street Pilsner 1
## 1153 King Winterbolt Winter Ale 1
## 1154 Kiss Off IPA 1
## 1155 Klickitat Pale Ale 1
## 1156 Klingon Warnog Roggen Dunkel 1
## 1157 Kludde 1
## 1158 Knotty Blonde Ale 1
## 1159 Knotty Pine 1
## 1160 Kodiak Brown Ale 1
## 1161 Kol' Beer 1
## 1162 Köld Lager 1
## 1163 Kölsch 151 1
## 1164 Kolschtal Eddy 1
## 1165 Kreamed Corn 1
## 1166 KSA 1
## 1167 L'il Lucy's Hot Pepper Ale 1
## 1168 La Ferme Urbaine Farmhouse Ale 1
## 1169 La Frontera Premium IPA 1
## 1170 La Perouse White 1
## 1171 Lahaina Town Brown 1
## 1172 Laimas Kölsch Style Ale 1
## 1173 Laka Laka Pineapple 1
## 1174 Lake Monster 1
## 1175 Lake Street Express 1
## 1176 Lakefire Rye Pale Ale 1
## 1177 Lancaster German Style Kölsch 1
## 1178 Larry Imperial IPA 1
## 1179 Lasso 1
## 1180 Last Call Imperial Amber Ale 1
## 1181 Last Stop IPA 1
## 1182 Laughing Dog Cream Ale 1
## 1183 Laughing Dog IPA 1
## 1184 Lava Lake Wit 1
## 1185 Lawnmower Lager 1
## 1186 Lazy Monk Bohemian Pilsner 1
## 1187 Le Flaneur Ale 1
## 1188 Leaning Chimney Smoked Porter 1
## 1189 Leatherhead Red 1
## 1190 Lee Hill Series Vol. 1 - Barrel Aged Brown Ale 1
## 1191 Lee Hill Series Vol. 2 - Wild Saison 1
## 1192 Lee Hill Series Vol. 3 - Barrel Aged Imperial Stout 1
## 1193 Lee Hill Series Vol. 4 - Manhattan Style Rye Ale 1
## 1194 Lee Hill Series Vol. 5 - Belgian Style Quadrupel Ale 1
## 1195 Left of the Dial IPA 1
## 1196 Leisure Time 1
## 1197 Lemon Shandy Tripel 1
## 1198 Lemongrass Saison 1
## 1199 Leprechaun Lager 1
## 1200 Leroy 1
## 1201 Let It Ride IPA 1
## 1202 Lewbricator Wheat Dopplebock 1
## 1203 Lewis & Clark Amber Ale 1
## 1204 Liberty Ale 1
## 1205 LIFT 1
## 1206 Lift Bridge Brown Ale 1
## 1207 Lift Off IPA 1
## 1208 Lighthouse Amber 1
## 1209 Lights Out Vanilla Cream Extra Stout 1
## 1210 Lil' Brainless Raspberries 1
## 1211 Lil' Helper 1
## 1212 Lil SIPA 1
## 1213 Lily Flagg Milk Stout 1
## 1214 Linnaeus Mango IPA 1
## 1215 Lionshead 1
## 1216 Liquid Amber Ale 1
## 1217 Liquid Breadfruit 1
## 1218 Little Boss 1
## 1219 Little Red Cap 1
## 1220 Little Sister India Style Session Ale 1
## 1221 Live Local Golden Ale 1
## 1222 Lizzy's Red 1
## 1223 Loafin Bräu 1
## 1224 Lobo Lito 1
## 1225 Local 5 Pale Ale 1
## 1226 Local Buzz 1
## 1227 Lomaland 1
## 1228 London Balling 1
## 1229 London Homesick Ale 1
## 1230 Long Day Lager 1
## 1231 Long Leaf 1
## 1232 Long Trail Ale 1
## 1233 Long Trail Ale (1) 1
## 1234 Long Trail IPA 1
## 1235 Longfin Lager 1
## 1236 Longhop IPA 1
## 1237 Loose Cannon 1
## 1238 Lost Galaxy 1
## 1239 Lost Meridian Wit 1
## 1240 Lost River Blonde Ale 1
## 1241 Lost Sailor IPA 1
## 1242 Lost Trout Brown Ale 1
## 1243 Louie's Demise Amber Ale 1
## 1244 Louie’s Demise Immort-Ale 1
## 1245 Love In An Ellavator 1
## 1246 Love Street Summer Seasonal 1
## 1247 Lower De Boom 1
## 1248 Luchesa Lager 1
## 1249 LuckenBock 1
## 1250 Lucky Buck 1
## 1251 Lucky Day IPA 1
## 1252 Lucky Dog 1
## 1253 Lucky U IPA 1
## 1254 Lumberyard IPA 1
## 1255 Lumberyard Pilsner 1
## 1256 Lumberyard Red Ale 1
## 1257 Lyric Ale 1
## 1258 Mac's Highlander Pale Ale 1
## 1259 Mac's Scottish Style Amber Ale 1
## 1260 Macon History Ale 1
## 1261 Macon Progress Ale 1
## 1262 Mad Beach 1
## 1263 Mad Manatee IPA 1
## 1264 Madra Allta 1
## 1265 Maggie's Leap 1
## 1266 Magic Apple 1
## 1267 Maine Island Trail Ale 1
## 1268 Maize & Blueberry 1
## 1269 Make It So 1
## 1270 Mana Wheat 1
## 1271 Manayunk IPA 1
## 1272 Manayunk Oktoberfest 1
## 1273 Mango Ginger 1
## 1274 Manhattan Gold Lager 1
## 1275 Manitou Amber 1
## 1276 Manzanita IPA 1
## 1277 Manzanita Pale Ale 1
## 1278 Marble India Pale Ale 1
## 1279 Marble Pilsner 1
## 1280 Marblehead 1
## 1281 Marooned On Hog Island 1
## 1282 Masked Bandit IPA 1
## 1283 Mastermind 1
## 1284 Mauna Kea Pale Ale 1
## 1285 Maxwell's Scottish Ale 1
## 1286 Maylani's Coconut Stout 1
## 1287 Mazzie 1
## 1288 MCA 1
## 1289 McKinney Eddy Amber Ale 1
## 1290 Meat Wave 1
## 1291 MechaHopzilla 1
## 1292 Mela 1
## 1293 Mexican Logger 1
## 1294 Miami Vice IPA 1
## 1295 Michelada 1
## 1296 Mickey Finn's Amber Ale 1
## 1297 Midnight Oil 1
## 1298 Midnight Ryder 1
## 1299 Midwest Charm Farmhouse Ale 1
## 1300 Might As Well IPL 1
## 1301 Milk Mustachio Stout 1
## 1302 Milkshake Stout 1
## 1303 Mind's Eye PA 1
## 1304 Mind Games 1
## 1305 Miner's Gold Hefeweizen 1
## 1306 Minhas Light 1
## 1307 Mirror Pond Pale Ale 1
## 1308 Missile IPA 1
## 1309 Mission IPA 1
## 1310 Mississippi Fire Ant 1
## 1311 Missouri Mule India Pale Ale 1
## 1312 Mistress Winter Wheat 1
## 1313 Misty Mountain Hop 1
## 1314 Misty Mountain IPA 1
## 1315 Mjöllnir 1
## 1316 Mjolnir Imperial IPA 1
## 1317 Mo's Gose 1
## 1318 Moar 1
## 1319 Moe's Original Bar B Que 'Bama Brew Golden Ale 1
## 1320 Moe Lasses' 1
## 1321 Moirai India Pale Ale 1
## 1322 Molotov Lite 1
## 1323 Monarch Classic American Wheat 1
## 1324 Monarch Pilsner 1
## 1325 Monk's Blood 1
## 1326 Monk from the 'Yunk 1
## 1327 Monkadelic 1
## 1328 Monkey Chased the Weasel 1
## 1329 Monkey Dancing On A Razor Blade 1
## 1330 Monkey Fist IPA 1
## 1331 Monkey Paw Oatmeal Pale Ale 1
## 1332 Monkeynaut IPA 1
## 1333 Monon Wheat 1
## 1334 Montauk Light 1
## 1335 Montauk Summer Ale 1
## 1336 Moo Thunder Stout 1
## 1337 Moped Traveler 1
## 1338 More Cowbell 1
## 1339 Morgan Street Oktoberfest 1
## 1340 Morning Wood 1
## 1341 Mosaic Single Hop IPA 1
## 1342 Mother Ale 1
## 1343 Mother in Lager 1
## 1344 Mothman Black IPA 1
## 1345 Mound Builder IPA 1
## 1346 Mountain Creek 1
## 1347 Mountain Fairy Raspberry Wheat 1
## 1348 Mountain Livin' Pale Ale 1
## 1349 Mountain Rescue Pale Ale 1
## 1350 Mr. Blue Sky 1
## 1351 Mr. Orange 1
## 1352 Mr. Pineapple 1
## 1353 Mr. Tea 1
## 1354 Mucho Aloha Hawaiian Pale Ale 1
## 1355 Murphy's Law 1
## 1356 Mustang '33 1
## 1357 Mustang Golden Ale 1
## 1358 Mustang Sixty-Six 1
## 1359 Mutiny IPA 1
## 1360 Mutton Buster 1
## 1361 Mystic Mama IPA 1
## 1362 Mystical Stout 1
## 1363 N Street Drive-In 50th Anniversary IPA 1
## 1364 Na Zdravà Pilsner 1
## 1365 Naked Pig Pale Ale 1
## 1366 Narragansett Bock 1
## 1367 Narragansett Bohemian Pilsner 1
## 1368 Narragansett Cream Ale 1
## 1369 Narragansett Fest Lager 1
## 1370 Narragansett Porter 1
## 1371 Neato Bandito 1
## 1372 Nebraska India Pale Ale 1
## 1373 Nectar of the Hops 1
## 1374 Neomexicanus Native 1
## 1375 New Cleveland Palesner 1
## 1376 Newburyport Pale Ale 1
## 1377 Newport Storm IPA 1
## 1378 Next Adventure Black IPA 1
## 1379 Nice Rack IPA 1
## 1380 Ninja Porter 1
## 1381 Nitro Can Coffee Stout 1
## 1382 No Limits Hefeweizen 1
## 1383 No Wake IPA 1
## 1384 Noche Dulce 1
## 1385 NOLA Blonde Ale 1
## 1386 NOLA Brown Ale 1
## 1387 Nomader Weiss 1
## 1388 Nooner 1
## 1389 Nordic Blonde 1
## 1390 Nordskye 1
## 1391 Norm's Gateway IPA 1
## 1392 Norm's Raggedy Ass IPA 1
## 1393 Norns Roggenbier 1
## 1394 North 45 Amber Ale 1
## 1395 North Fork Lager 1
## 1396 North French 1
## 1397 North Third Stout 1
## 1398 Northern Hawk Owl Amber 1
## 1399 Northern Lights Amber Ale 1
## 1400 Notch Session Pils 1
## 1401 November Gale Pale Ale 1
## 1402 Nuclear Winter 1
## 1403 Nugget Nectar 1
## 1404 Nuit Serpent 1
## 1405 Number 22 Porter 1
## 1406 Nunica Pine 1
## 1407 Nut Brown Ale 1
## 1408 Nut Sack Imperial Brown Ale 1
## 1409 O'Fallon Pumpkin Beer 1
## 1410 O'Fallon Wheach 1
## 1411 O-Gii 1
## 1412 O’Malley’s IPA 1
## 1413 O’Malley’s Irish Style Cream Ale 1
## 1414 O’Malley’s Stout 1
## 1415 Oak Aged Cider 1
## 1416 Oak Cliff Coffee Ale 1
## 1417 Oakshire Amber Ale 1
## 1418 Oaky's Oatmeal Stout 1
## 1419 Oatmeal PSA 1
## 1420 OB-1 Organic Ale 1
## 1421 Occidental Altbier 1
## 1422 Occidental Dunkel 1
## 1423 Occidental Hefeweizen 1
## 1424 Occidental Kölsch 1
## 1425 Odyssey Imperial IPA 1
## 1426 OH-PA Session Pale Ale 1
## 1427 Oklahoma Suks 1
## 1428 OktoberBeast 1
## 1429 Oktoberfest Lager 1
## 1430 Oktoberfest Revolution 1
## 1431 OktoberFiesta 1
## 1432 Ol' Factory Pils 1
## 1433 Old Chico Crystal Wheat 1
## 1434 Old Chub NITRO 1
## 1435 Old Detroit 1
## 1436 Old Devil's Tooth 1
## 1437 Old Elephant Foot IPA 1
## 1438 Old Forge Pumpkin Ale 1
## 1439 Old Potentate 1
## 1440 Old Pro 1
## 1441 Old Red Beard Amber Ale 1
## 1442 Old Soul 1
## 1443 Old Tom Porter 1
## 1444 Old Town Ale 1
## 1445 Old Wylie's IPA 1
## 1446 Olde Ore Dock Scottish Ale 1
## 1447 On-On Ale 1
## 1448 On the Count of 3 1
## 1449 On the Wings of Armageddon 1
## 1450 One-Hit Wonderful 1
## 1451 One Claw 1
## 1452 One Hit Wonder 1
## 1453 Oneida 1
## 1454 Onyx Black Ale 1
## 1455 Operation Homefront 1
## 1456 Orabelle 1
## 1457 Orange Grove Wheat Ale 1
## 1458 Orange Wheat 1
## 1459 Oregon Trail Unfiltered Raspberry Wheat 1
## 1460 Organic Baba Black Lager 1
## 1461 Original 1
## 1462 Original Orange Blossom Ale (Current) 1
## 1463 Original Slacker Ale 1
## 1464 Orignal Blend 1
## 1465 Orlison India Pale Lager 1
## 1466 Ornery Amber Lager 1
## 1467 Oval Beach Blonde Ale 1
## 1468 Over Ale 1
## 1469 Over the Rail Pale Ale 1
## 1470 Overbite IPA 1
## 1471 Overcast Espresso Stout 1
## 1472 Overgrown American Pale Ale 1
## 1473 Overlord Imperial IPA 1
## 1474 Overrated! West Coast Style IPA 1
## 1475 Owney Irish Style Red Ale 1
## 1476 Ozark American Pale Ale 1
## 1477 Ozzy 1
## 1478 P-51 Porter 1
## 1479 P-Town Pilsner 1
## 1480 Pablo Beach Pale Ale 1
## 1481 Pace Setter Belgian Style Wit 1
## 1482 Paddy Pale Ale 1
## 1483 Pail Ale 1
## 1484 Painted Turtle 1
## 1485 Pako’s EyePA 1
## 1486 Palate Mallet 1
## 1487 Pale 1
## 1488 Pale Dog 1
## 1489 Paleo IPA 1
## 1490 Pallavicini Pilsner 1
## 1491 Pamola Xtra Pale Ale 1
## 1492 Panorama Wheat Ale 1
## 1493 Panther 1
## 1494 Parade Ground Coffee Porter 1
## 1495 Parapet ESB 1
## 1496 Parcae Belgian Style Pale Ale 1
## 1497 Paris 1
## 1498 Park 1
## 1499 Passenger 1
## 1500 Passion Fruit Prussia 1
## 1501 Patrick's Poison 1
## 1502 Patty's Chile Beer 1
## 1503 Pau Hana Pilsner 1
## 1504 Pay It Forward Cocoa Porter 1
## 1505 Payette Pale Ale 1
## 1506 Peacemaker 1
## 1507 Peacemaker Pale Ale 1
## 1508 Peacemaker Pilsner 1
## 1509 Peach Pale Ale 1
## 1510 Peaches & Cream 1
## 1511 Peanut Butter Jelly Time 1
## 1512 Pearl-Snap 1
## 1513 Peck's Porter 1
## 1514 Peninsula Brewers Reserve (PBR) 1
## 1515 Penn Quarter Porter 1
## 1516 People's Pale Ale 1
## 1517 People's Pilsner 1
## 1518 Pepper in the Rye 1
## 1519 Perfect Tin Amber 1
## 1520 Pernicious Double IPA 1
## 1521 Perpetual Darkness 1
## 1522 Perpetual IPA 1
## 1523 Persnickety Pale 1
## 1524 Perzik Saison 1
## 1525 Pete's ESP Lager 1
## 1526 Pete's Wicked Bohemian Pilsner 1
## 1527 Pete's Wicked Pale Ale 1
## 1528 Petit Mutant 1
## 1529 Phantom Punch Winter Stout 1
## 1530 Phat Chance 1
## 1531 Phoenix Pale Ale 1
## 1532 Pick Axe Blonde Ale 1
## 1533 Pigwar White India Pale Ale 1
## 1534 Pikeland Pils 1
## 1535 Pile O'Dirt Porter 1
## 1536 Pile of Face 1
## 1537 Pilot Rock Porter 1
## 1538 Pilsner Ukiah 1
## 1539 Pilzilla 1
## 1540 Pinata Protest 1
## 1541 Pine Knob Pilsner 1
## 1542 Pink-I Raspberry IPA 1
## 1543 Pinner Throwback IPA 1
## 1544 Pisgah Pale Ale 1
## 1545 Pistols at Dawn 1
## 1546 Pit Stop Chocolate Porter 1
## 1547 Pivo Pils 1
## 1548 Pleasure Town 1
## 1549 Pleasure Town IPA 1
## 1550 Plow Horse Belgian Style Imperial Stout 1
## 1551 Plowshare Porter 1
## 1552 Plum Island Belgian White 1
## 1553 Point Amber Classic 1
## 1554 Point Special (Current) 1
## 1555 Polar Night Stout 1
## 1556 Polar Pale Ale 1
## 1557 Pole Barn Stout 1
## 1558 Poleeko Gold Pale Ale 1
## 1559 Pomegranate Wheat 1
## 1560 Ponderosa IPA 1
## 1561 PONTO S.I.P.A. 1
## 1562 Pony Pilsner 1
## 1563 Poop Deck Porter 1
## 1564 Pop's Old Fashioned Lager 1
## 1565 Popcorn Pilsner 1
## 1566 Porch Rocker 1
## 1567 Porkslap Pale Ale 1
## 1568 Port Barrel Wee Mac 1
## 1569 Porter (a/k/a Black Gold Porter) 1
## 1570 Porter Culture 1
## 1571 Post Time Kölsch 1
## 1572 Pothole Stout 1
## 1573 Powder Hound Winter Ale 1
## 1574 Power & Light 1
## 1575 Power House Porter 1
## 1576 Pre Flight Pilsner 1
## 1577 Preservation IPA 1
## 1578 Presidential Pils 1
## 1579 Pretzel Stout 1
## 1580 Pride of Texas Pale Ale 1
## 1581 PRO-AM (2012) 1
## 1582 Professor Black 1
## 1583 Provision 1
## 1584 Proxima IPA 1
## 1585 Psycho Penguin Vanilla Porter 1
## 1586 Psychopathy 1
## 1587 Psychopomp 1
## 1588 Pt. Bonita Rustic Lager 1
## 1589 Pub Ale 1
## 1590 Pub Beer 1
## 1591 Pump House IPA 1
## 1592 Pumpion 1
## 1593 Pumpkan 1
## 1594 Pumpkin Ale 1
## 1595 Pumpkin Beast 1
## 1596 Pumpkin Porter 1
## 1597 Pumpkin Tart 1
## 1598 Pumpkinhead Ale 1
## 1599 Pumple Drumkin 1
## 1600 PUNK'N 1
## 1601 Puppy's Breath Porter 1
## 1602 Pure Fury 1
## 1603 Purple Haze 1
## 1604 Pursuit 1
## 1605 PV Muckle 1
## 1606 Pyramid Hefeweizen 1
## 1607 Quaff India Style Session Ale 1
## 1608 Quakertown Stout 1
## 1609 Quarter Mile Double IPA 1
## 1610 Quick WIT 1
## 1611 Quick Wit Belgianesque Ale 1
## 1612 Rad 1
## 1613 Rahr's Blonde 1
## 1614 Rail Slide Imperial Spiced Ale 1
## 1615 Raincloud Robust Porter 1
## 1616 Raja 1
## 1617 Ranger IPA (Current) 1
## 1618 Raspberry Berliner Weisse 1
## 1619 Ray Ray’s Pale Ale 1
## 1620 Razz Wheat 1
## 1621 Reactor 1
## 1622 Real McCoy Amber Ale (Current) 1
## 1623 Rebel IPA 1
## 1624 Rebirth Pale Ale 1
## 1625 RecreationAle 1
## 1626 Red Clay IPA 1
## 1627 Red Jacket Amber Ale 1
## 1628 Red Mountain Ale 1
## 1629 Red Water Irish Style Red 1
## 1630 Redacted Rye IPA 1
## 1631 Redband Stout 1
## 1632 Regional Ring Of Fire 1
## 1633 Remain in Light 1
## 1634 Reprise Centennial Red 1
## 1635 Resin 1
## 1636 Resolution Rye Stout 1
## 1637 Resurrected 1
## 1638 Resurrection 1
## 1639 Rhino Chasers Pilsner 1
## 1640 Rhode Island Blueberry 1
## 1641 Rhubarbarian 1
## 1642 Rich Man's IIPA 1
## 1643 Rico Sauvin 1
## 1644 Ride Again Pale Ale 1
## 1645 Ring of Dingle 1
## 1646 Rip Van Winkle (Current) 1
## 1647 Rise-Up Red 1
## 1648 Rise of the Phoenix 1
## 1649 Rise to the Top 1
## 1650 Rise Up Red 1
## 1651 River House 1
## 1652 River House Saison 1
## 1653 River North Ale 1
## 1654 River North White Ale 1
## 1655 River Pig Pale Ale 1
## 1656 River Runners Pale Ale 1
## 1657 Riverwalk Blonde Ale 1
## 1658 Rivet Irish Red Ale 1
## 1659 Road 2 Ruin Double IPA 1
## 1660 Robert Earl Keen Honey Pils 1
## 1661 Rochester Red Ale 1
## 1662 Rocket Bike American Lager 1
## 1663 Rocket Girl 1
## 1664 Rocky Mountain Oyster Stout 1
## 1665 Rod Bender Red 1
## 1666 Rodeo Clown Double IPA 1
## 1667 Rodeo Rye Pale Ale 1
## 1668 Rogue American Amber Ale 1
## 1669 Roler Bock (Current) 1
## 1670 Rollin Dirty Red Ale 1
## 1671 Root Stock 1
## 1672 Rosa Hibiscus Ale 1
## 1673 RoughTail IPA 1
## 1674 Royal Brat 1
## 1675 Royal Lager 1
## 1676 Royal Weisse Ale 1
## 1677 RT Lager 1
## 1678 Rubberneck Red 1
## 1679 Rude Parrot IPA 1
## 1680 Rudie Session IPA 1
## 1681 Rudolph's Red 1
## 1682 Ruhstaller's Gilt Edge Lager Beer 1
## 1683 Rule G IPA 1
## 1684 Rules are Rules 1
## 1685 Rumble 1
## 1686 Rumspringa Golden Bock 1
## 1687 Rustic Red 1
## 1688 Rusty Nail Pale Ale 1
## 1689 Rye Knot 1
## 1690 Rye Pils Session Lager 1
## 1691 Rye Wit 1
## 1692 Ryecoe 1
## 1693 Ryeteous Rye IPA 1
## 1694 Saint Archer Blonde 1
## 1695 Saint Archer IPA 1
## 1696 Saint Archer Pale Ale 1
## 1697 Saint Archer White Ale 1
## 1698 Saison 88 1
## 1699 Saison Pamplemousse 1
## 1700 Salamander Slam 1
## 1701 Samuel Adams Octoberfest 1
## 1702 Samuel Adams Summer Ale 1
## 1703 Samuel Adams Winter Lager 1
## 1704 Sanctified 1
## 1705 Sand Island Lighthouse 1
## 1706 Sanitas Black IPA 1
## 1707 Sanitas Saison Ale 1
## 1708 Sankaty Light Lager 1
## 1709 Santa's Secret 1
## 1710 Santa Fe Irish Red Ale 1
## 1711 Santa Fe Oktoberfest 1
## 1712 Saranac Adirondack Light 1
## 1713 Saranac Golden Pilsener 1
## 1714 Saranac Pale Ale (12 oz.) 1
## 1715 Saranac Pale Ale (16 oz.) 1
## 1716 Saranac Shandy 1
## 1717 Saranac Summer Ale 1
## 1718 Saranac Traditional Lager 1
## 1719 Saranac White IPA 1
## 1720 Saucy Intruder 1
## 1721 Savannah Brown Ale 1
## 1722 Sawtooth Ale 1
## 1723 Scarecrow 1
## 1724 Schilling Hard Cider 1
## 1725 Schlafly American Brown Ale 1
## 1726 Schlafly Black Lager 1
## 1727 Schlafly Hefeweizen 1
## 1728 Schlafly IPA 1
## 1729 Schlafly Summer Lager 1
## 1730 Schlafly Yakima Wheat Ale 1
## 1731 Schoolhouse Honey 1
## 1732 Schuylkill Punch 1
## 1733 Schweet Ale 1
## 1734 Scotty K NA 1
## 1735 Screamin’ Pumpkin 1
## 1736 Screaming Eagle Special Ale ESB 1
## 1737 Scruffy's Smoked Alt 1
## 1738 Sculpin IPA 1
## 1739 Sea Dog Wild Blueberry Wheat Ale 1
## 1740 Sea Hag IPA 1
## 1741 Sea Hag IPA (Current) 1
## 1742 Second Fiddle 1
## 1743 Second Wind Pale Ale 1
## 1744 Secret Stache Stout 1
## 1745 Seiche Scottish Ale 1
## 1746 Self Starter 1
## 1747 Send Help 1
## 1748 Sensi Harvest 1
## 1749 Session '33 1
## 1750 Seven Gates Pale Ale 1
## 1751 Seventh Son Hopped Red Ale 1
## 1752 Seventh Son of a Seventh Son 1
## 1753 Sex and Candy 1
## 1754 Sexy Chaos 1
## 1755 Shark Bait 1
## 1756 Shark Tracker Light lager 1
## 1757 Shenanigans Summer Ale 1
## 1758 Shift (1) 1
## 1759 Shipwrecked Double IPA 1
## 1760 Shipyard Export 1
## 1761 Shipyard Summer Ale 1
## 1762 Shiva IPA 1
## 1763 Sho'nuff 1
## 1764 Shotgun Betty 1
## 1765 Siamese twin 1
## 1766 Side Kick Kölsch 1
## 1767 Sidekick Extra Pale Ale 1
## 1768 Sietsema Red Label 1
## 1769 Silverback Pale Ale 1
## 1770 Single Engine Red 1
## 1771 Single Hop Ale 1
## 1772 Sinister 1
## 1773 Sinister Minister Black IPA 1
## 1774 Sir William's English Brown Ale 1
## 1775 Ski Patrol 1
## 1776 Sky-Five 1
## 1777 Sky Blue Golden Ale 1
## 1778 Sky High Rye 1
## 1779 Skylight 1
## 1780 Slimy Pebble Pils 1
## 1781 Slow & Steady Golden Ale 1
## 1782 Slow Hand Stout 1
## 1783 Sly Fox Christmas Ale 2012 1
## 1784 Sly Fox Christmas Ale 2013 1
## 1785 Smitten 1
## 1786 Smittytown 1
## 1787 Smoking Mirror 1
## 1788 Smoky Wheat 1
## 1789 Smooth Operator 1
## 1790 Snaggletooth Double Pale Ale 1
## 1791 Snake Dog IPA 1
## 1792 Snake Handler Double IPA 1
## 1793 Snake River Lager 1
## 1794 Snake River Pale Ale 1
## 1795 Snapperhead IPA 1
## 1796 Snapshot 1
## 1797 SNO White Ale 1
## 1798 Snow King Pale Ale 1
## 1799 Snowcat Coffee Stout 1
## 1800 Snowshoe White Ale 1
## 1801 Sobek & Set 1
## 1802 Sobrehumano Palena'ole 1
## 1803 Sockeye Belgian Style Summer Ale 1
## 1804 Sockeye Maibock 1
## 1805 Sockeye Red IPA 1
## 1806 Socktoberfest 1
## 1807 SoDo Brown Ale 1
## 1808 Sol Drifter 1
## 1809 Solis 1
## 1810 Solitude 1
## 1811 Sophomoric Saison 1
## 1812 Soul Doubt 1
## 1813 Sous Chef 1
## 1814 South Bay Session IPA 1
## 1815 South Ridge Amber Ale 1
## 1816 Southern Cross 1
## 1817 Southern Drawl Pale Lager 1
## 1818 Sparkle 1
## 1819 Special Edition: Allies Win The War! 1
## 1820 Special Release 1
## 1821 Spin Doctor 1
## 1822 Spirit Animal 1
## 1823 Spiteful IPA 1
## 1824 Sprocket Blonde Ale 1
## 1825 Sprocket Pale Ale 1
## 1826 SPRYE 1
## 1827 Squeaky Bike Nut Brown Ale 1
## 1828 St. Benedict's Winter Ale 1
## 1829 Star Runner 1
## 1830 Stargrazer 1
## 1831 Starr Pils 1
## 1832 Station 33 Firehouse Red 1
## 1833 Steam Engine Lager 1
## 1834 Steel Rail Extra Pale Ale 1
## 1835 Steel Wheels ESB 1
## 1836 Stickin' In My Rye 1
## 1837 Stimulator Pale Ale 1
## 1838 Stir Crazy Winter Ale 1
## 1839 Stone's Throw IPA 1
## 1840 Stone Fort Brown Ale 1
## 1841 Stone of Arbroath 1
## 1842 Stowaway IPA 1
## 1843 Straub Beer (Current) 1
## 1844 Strawberry Blonde 1
## 1845 Strawberry White 1
## 1846 Striped Bass Pale Ale 1
## 1847 Stronghold 1
## 1848 Stump Knocker Pale Ale 1
## 1849 Stupid Sexy Flanders 1
## 1850 Sucha Much IPA 1
## 1851 Sudice American Stout 1
## 1852 Sugar Plum 1
## 1853 Suicide Blonde IPA 1
## 1854 Suicide Squeeze IPA 1
## 1855 SUM'R 1
## 1856 Summer's Wit 1
## 1857 Summer Ale 1
## 1858 Summer Brew 1
## 1859 Summer Honey 1
## 1860 Summer of Lager 1
## 1861 Summer Paradise 1
## 1862 Summer Session Ale 1
## 1863 Summer Solstice Cerveza Crema 1
## 1864 Summer Swelter 1
## 1865 Summer Wheat 1
## 1866 SummerBright Ale 1
## 1867 Summerfest 1
## 1868 Summertime Ale 1
## 1869 Suncaster Summer Wheat 1
## 1870 Sundown 1
## 1871 Sunken Island IPA 1
## 1872 Sunlight Cream Ale 1
## 1873 Sunny Haze 1
## 1874 Sunrise Oatmeal Pale Ale 1
## 1875 Sunset Amber 1
## 1876 Sunshine Nectar 1
## 1877 Sunshine Pils 1
## 1878 Sunsplash Golden Ale 1
## 1879 SunSpot Golden Ale 1
## 1880 Super G IPA 1
## 1881 Supergoose IPA 1
## 1882 Supermonk I.P.A. 1
## 1883 Supper Club Lager 1
## 1884 Surfrider 1
## 1885 SurlyFest 1
## 1886 Survival Stout 1
## 1887 Swami's India Pale Ale 1
## 1888 Sweet As Pacific Ale 1
## 1889 Sweet Georgia Brown 1
## 1890 Sweet Josie 1
## 1891 Sweet Potato Ale 1
## 1892 Sweet Yamma Jamma Ale 1
## 1893 SweetWater IPA 1
## 1894 Sympathy for the Lager 1
## 1895 T-6 Red Ale 1
## 1896 T-Rail Pale Ale 1
## 1897 TailGate Saison 1
## 1898 Take Two Pils 1
## 1899 Tallgrass Ale 1
## 1900 Tallgrass IPA 1
## 1901 Tallgrass Pub Ale 1
## 1902 Tampa Pale Ale 1
## 1903 Tarasque 1
## 1904 Tarnation California-Style Lager 1
## 1905 Tart Side of the Barrel 1
## 1906 Tart Side of the Moon 1
## 1907 Taster's Choice 1
## 1908 Tejas Lager 1
## 1909 Tempter IPA 1
## 1910 Ten Fidy 1
## 1911 Tender Loving Empire NWPA 1
## 1912 Tent Pole Vanilla Porter 1
## 1913 Terlingua Gold 1
## 1914 Terrace Hill Double IPA 1
## 1915 Testudo 1
## 1916 Texas Pale Ale (TPA) 1
## 1917 Texicali 1
## 1918 Thai Style White IPA 1
## 1919 Thai.p.a 1
## 1920 Thanksgiving Ale 1
## 1921 The 12th Canâ„¢ 1
## 1922 The 26th 1
## 1923 The Citizen 1
## 1924 The Corruption 1
## 1925 The CROWLERâ„¢ 1
## 1926 The Crusher 1
## 1927 The Farmer's Daughter 1
## 1928 The Gadget 1
## 1929 The Gilded Age 1
## 1930 The Golden One 1
## 1931 The Grand Army 1
## 1932 The Great Pumpcan 1
## 1933 The Great Return 1
## 1934 The Green Room 1
## 1935 The Hole in Hadrian's Wall 1
## 1936 the Kimmie, the Yink and the Holy Gose 1
## 1937 The Lawn Ranger 1
## 1938 The Long Thaw White IPA 1
## 1939 The One They Call Zoe 1
## 1940 The Optimist 1
## 1941 The Power of Zeus 1
## 1942 The Public 1
## 1943 The Sword Iron Swan Ale 1
## 1944 The Tradition 1
## 1945 The Velvet Fog 1
## 1946 There Will Be Stout 1
## 1947 Third Eye Enlightened Pale Ale 1
## 1948 Third Eye Pale Ale 1
## 1949 This Season's Blonde 1
## 1950 THP Amber 1
## 1951 THP Dark 1
## 1952 THP Light 1
## 1953 THP White 1
## 1954 Thrasher Session India Pale Ale 1
## 1955 Threadless IPA 1
## 1956 Three Kings Ale 1
## 1957 Three Skulls Ale Pale Ale 1
## 1958 Three Way Pale Ale 1
## 1959 Thunder Ann 1
## 1960 Thunder Snow 1
## 1961 Tin Roof Blonde Ale 1
## 1962 Tin Roof Watermelon Wheat 1
## 1963 Tiny Bomb 1
## 1964 Tip Off 1
## 1965 Titan IPA 1
## 1966 Toasted Lager 1
## 1967 Tocobaga Red Ale 1
## 1968 Todd the Axe Man 1
## 1969 Tonganoxie Honey Wheat 1
## 1970 Top Rope Mexican-style Craft Lager 1
## 1971 Topcutter India Pale Ale 1
## 1972 Totally Radler 1
## 1973 Totally Roasted 1
## 1974 Toughcats IPA 1
## 1975 Tour de Nez Belgian IPA (Current) 1
## 1976 Towhead 1
## 1977 Toxic Sludge 1
## 1978 Track 1 Amber Lager 1
## 1979 Trader Session IPA 1
## 1980 Trail Head 1
## 1981 Trail Maker Pale Ale 1
## 1982 Trailhead India Style Session Ale 1
## 1983 Trailhead ISA 1
## 1984 Train Hopper 1
## 1985 Train Wreck 1
## 1986 Trauger Pilsner 1
## 1987 Tree Bucket 1
## 1988 Triangle Belgian Golden Ale 1
## 1989 Triangle India Pale Ale 1
## 1990 Triangle White Ale 1
## 1991 Tribute 1
## 1992 Trigger Blonde Ale 1
## 1993 Triomphe 1
## 1994 Tripel Deke 1
## 1995 Troegenator 1
## 1996 Troegenator Doublebock 1
## 1997 Troll Destroyer 1
## 1998 Trolley Stop Stout 1
## 1999 Troopers Alley IPA 1
## 2000 Tropical Heatwave 1
## 2001 Tropical Saison 1
## 2002 Tropicalia 1
## 2003 Truck Stop Honey Brown Ale 1
## 2004 True Blonde Ale 1
## 2005 Truth 1
## 2006 Tug Pale Ale 1
## 2007 Tule Duck Red Ale (Current) 1
## 2008 Tumbleweed IPA 1
## 2009 Turnrow Harvest Ale 1
## 2010 Twisted Helles Summer Lager 1
## 2011 Twisted X 1
## 2012 Twister Creek India Pale Ale 1
## 2013 Two-One Niner 1
## 2014 Two Hearted 1
## 2015 Tybee Island Blonde 1
## 2016 U. P. Witbier 1
## 2017 U.S. Pale Ale 1
## 2018 Uber Lupin Schwarz IPA 1
## 2019 UFO Gingerland 1
## 2020 UFO Pumpkin 1
## 2021 UFO White 1
## 2022 Ultra Gnar Gnar IPA 1
## 2023 Unchained #18 Hop Silo 1
## 2024 Uncle John's Apple Cherry Cider 1
## 2025 Uncle John's Apricot Apple Cider 1
## 2026 Underachiever 1
## 2027 Underdog Atlantic Lager 1
## 2028 Union Jack 1
## 2029 Universale Pale Ale 1
## 2030 Up River Light 1
## 2031 Upland Wheat Ale 1
## 2032 Upslope Belgian Style Pale Ale 1
## 2033 Upslope Brown Ale 1
## 2034 Upslope Christmas Ale 1
## 2035 Upslope Craft Lager 1
## 2036 Upslope Foreign Style Stout 1
## 2037 Upslope Imperial India Pale Ale 1
## 2038 Upslope India Pale Ale 1
## 2039 Upslope Pale Ale 1
## 2040 Upslope Pumpkin Ale 1
## 2041 Upstate I.P.W. 1
## 2042 Urban Wilderness Pale Ale 1
## 2043 Uroboros 1
## 2044 Valkyrie Double IPA 1
## 2045 Van Dayum! 1
## 2046 Vanilla Bean Buffalo Sweat 1
## 2047 Vanilla Java Porter 1
## 2048 Velvet Rooster 1
## 2049 Venture Pils 1
## 2050 Verdun 1
## 2051 Vermont Pilsner 1
## 2052 Vernal Minthe Stout 1
## 2053 Vertex IPA 1
## 2054 Very Noddy Lager (Current) 1
## 2055 Veteran’s Pale Ale (VPA) 1
## 2056 Vienna Lager 1
## 2057 Viennese Lager 1
## 2058 Viking Ice Hole 1
## 2059 Villager 1
## 2060 Vinyl Frontier 1
## 2061 Vivant Belgian Style Imperial Stout 1
## 2062 Volcano Red Ale 1
## 2063 Voodoo 1
## 2064 Voodoo Bengal Pale Ale 1
## 2065 Voodoo Love Child 1
## 2066 Vortex IPA 1
## 2067 W.I.P.A Snappa 1
## 2068 Wachusett Blueberry Ale 1
## 2069 Wachusett IPA 1
## 2070 Wachusett Summer 1
## 2071 Wagon Box Wheat Beer 1
## 2072 Wagon Party 1
## 2073 Wall's End 1
## 2074 Walter's Premium Pilsener Beer 1
## 2075 Wandering Pelican 1
## 2076 Wapiti Amber Ale 1
## 2077 Wasatch Apricot Hefeweizen 1
## 2078 Washita Wheat 1
## 2079 Waterkeeper 1
## 2080 Watermelon Wheat 1
## 2081 Watership Brown Ale 1
## 2082 Wavemaker 1
## 2083 Wee-Heavy-Er Scotch Ale 1
## 2084 Wee Mac Scottish-Style Ale 1
## 2085 Weekend Warrior Pale Ale 1
## 2086 Weim-R-Iner 1
## 2087 Weiss Trash Culture 1
## 2088 Weiss Weiss Baby 1
## 2089 Weissenheimer 1
## 2090 Weize Guy 1
## 2091 Welcome to Scoville 1
## 2092 West Portal Colorado Common Summer Ale 1
## 2093 West Sixth Amber Ale 1
## 2094 West Sixth IPA 1
## 2095 Westbrook Gose 1
## 2096 Westbrook IPA 1
## 2097 Westfalia 1
## 2098 Westfield Octoberfest 1
## 2099 WET 1
## 2100 Wet Hot American Wheat Ale 1
## 2101 Whale's Tale Pale Ale 1
## 2102 What the Butler Saw 1
## 2103 Wheat the People 1
## 2104 When Helles Freezes Over 1
## 2105 Whip Fight 1
## 2106 White 1
## 2107 White Ale 1
## 2108 White Cap White IPA 1
## 2109 White Magick of the Sun 1
## 2110 White Rabbit 1
## 2111 White Rascal 1
## 2112 White Reaper 1
## 2113 White Thai 1
## 2114 White Water Wheat 1
## 2115 Whitecap Wit 1
## 2116 Whitewater 1
## 2117 Whitsun 1
## 2118 Wick For Brains 1
## 2119 Widespread Wit 1
## 2120 Widmer Brothers Hefeweizen 1
## 2121 Widow Maker Black Ale 1
## 2122 Wild Night 1
## 2123 Wild Onion Pumpkin Ale 1
## 2124 Wild Onion Summer Wit 1
## 2125 Wild Plum Farmhouse Ale 1
## 2126 Wild Trail Pale Ale 1
## 2127 Wild Wolf American Pilsner 1
## 2128 Wild Wolf Wee Heavy Scottish Style Ale 1
## 2129 Will Power Pale Ale 1
## 2130 Wind River Blonde Ale 1
## 2131 Winter Games Select #32 Stout 1
## 2132 Winter Solstice 1
## 2133 Winter Warmer (Vault Series) 1
## 2134 Winter White 1
## 2135 Winterfest 1
## 2136 WinterWonderGrass Festival Ale 1
## 2137 Wiregrass Post-Prohibition Ale 1
## 2138 Wisco Disco 1
## 2139 Wizard Burial Ground 1
## 2140 Wobble 1
## 2141 Wolfman's Berliner 1
## 2142 Wolverine Premium Lager 1
## 2143 Wonderstuff 1
## 2144 Wood Chipper India Pale Ale 1
## 2145 Woodchuck Amber Hard Cider 1
## 2146 Wooden Rooster 1
## 2147 Woolybugger Wheat 1
## 2148 Workers Comp Saison 1
## 2149 Working for the Weekend 1
## 2150 Worthy Pale 1
## 2151 Wrath of Pele 1
## 2152 WYLD Extra Pale Ale 1
## 2153 Wynkoop Pumpkin Ale 1
## 2154 Wynona's Big Brown Ale 1
## 2155 Wyoming Pale Ale 1
## 2156 Yabba Dhaba Chai Tea Porter 1
## 2157 Yard Sale Amber Ale 1
## 2158 Yard Sale Winter Lager 1
## 2159 Yellow Collar 1
## 2160 Yellow Wolf Imperial IPA 1
## 2161 Yellowstone Golden Ale 1
## 2162 Yeti Imperial Stout 1
## 2163 Yo Soy Un Berliner 1
## 2164 Yonder Bock 1
## 2165 Yoshi's Nectar 1
## 2166 You're My Boy, Blue 1
## 2167 Yunkin' Punkin' 1
## 2168 Zen 1
## 2169 Zombie Monkie 1
## 2170 Zonker Stout 1# Remove beers with the same name, removes 240 unwanted duplicates
BeerData = BeerData %>% group_by(Name) %>% filter(!duplicated(Name))# Manually add in missing data for beers for question/item #3
# Parsing through the data, we can see that a large amount of information from the IBV and ABV values of beer are missing.
# While it is possible to hand-fill out values for both, counting the total number of missing values over both groups add up to over 1000 missing values.
# For the most part, we can ignore the missing data, but we cannot prove that the missing data is truly random.
# While we can perform an analysis on the data, we must be cautious as to the bias the exclusion of missing data could apply to our results.
# After googling various beers without IBU's and looking for the missing value it seems like many are hard to find
BeerData[BeerData$Name == "Lee Hill Series Vol. 5 - Belgian Style Quadrupel Ale",]$IBU = 35
BeerData[BeerData$Name == "Pub Beer",]$IBU = 18
BeerData[BeerData$Name == "Sinister",]$IBU = 30
#gg_miss_var(BeerData) Did not work as intended, might use to visualize missing values, might not be necessary# Merge beer data with breweries data for question/item #2
names(BreweriesData)[1] = "Brewery_id"
mergedBeerData = merge(BeerData, BreweriesData, by = "Brewery_id")
head(mergedBeerData, 6)## Brewery_id Name.x Beer_ID ABV IBU
## 1 1 Get Together 2692 0.045 50
## 2 1 Maggie's Leap 2691 0.049 26
## 3 1 Wall's End 2690 0.048 19
## 4 1 Pumpion 2689 0.060 38
## 5 1 Stronghold 2688 0.060 25
## 6 1 Parapet ESB 2687 0.056 47
## Style Ounces Name.y City
## 1 American IPA 16 NorthGate Brewing Minneapolis
## 2 Milk / Sweet Stout 16 NorthGate Brewing Minneapolis
## 3 English Brown Ale 16 NorthGate Brewing Minneapolis
## 4 Pumpkin Ale 16 NorthGate Brewing Minneapolis
## 5 American Porter 16 NorthGate Brewing Minneapolis
## 6 Extra Special / Strong Bitter (ESB) 16 NorthGate Brewing Minneapolis
## State
## 1 MN
## 2 MN
## 3 MN
## 4 MN
## 5 MN
## 6 MNtail(mergedBeerData, 6)## Brewery_id Name.x Beer_ID ABV IBU
## 2165 556 Pilsner Ukiah 98 0.055 NA
## 2166 557 Heinnieweisse Weissebier 52 0.049 NA
## 2167 557 Snapperhead IPA 51 0.068 NA
## 2168 557 Moo Thunder Stout 50 0.049 NA
## 2169 557 Porkslap Pale Ale 49 0.043 NA
## 2170 558 Urban Wilderness Pale Ale 30 0.049 NA
## Style Ounces Name.y City
## 2165 German Pilsener 12 Ukiah Brewing Company Ukiah
## 2166 Hefeweizen 12 Butternuts Beer and Ale Garrattsville
## 2167 American IPA 12 Butternuts Beer and Ale Garrattsville
## 2168 Milk / Sweet Stout 12 Butternuts Beer and Ale Garrattsville
## 2169 American Pale Ale (APA) 12 Butternuts Beer and Ale Garrattsville
## 2170 English Pale Ale 12 Sleeping Lady Brewing Company Anchorage
## State
## 2165 CA
## 2166 NY
## 2167 NY
## 2168 NY
## 2169 NY
## 2170 AK# Find the beer with the largest ABV and IBU and return those row for question #5
# The beer with the highest ABV is the Lee Hill Series Vol. 5 – Belgian Style Quadrupel Ale at 12.8% ABV from the state of Colorado
# The beer with the highest IBU is the Bitter Bitch Imperial IPA with an ABU of 138 from Oregon
"Highest ABV:"## [1] "Highest ABV:"max(mergedBeerData$ABV, na.rm = TRUE)## [1] 0.128"Highest IBU:"## [1] "Highest IBU:"max(mergedBeerData$IBU, na.rm = TRUE)## [1] 138mergedBeerData[which.max(mergedBeerData$ABV),]## Brewery_id Name.x Beer_ID
## 343 52 Lee Hill Series Vol. 5 - Belgian Style Quadrupel Ale 2565
## ABV IBU Style Ounces Name.y City State
## 343 0.128 35 Quadrupel (Quad) 19.2 Upslope Brewing Company Boulder COmergedBeerData[which.max(mergedBeerData$IBU),]## Brewery_id Name.x Beer_ID ABV IBU
## 1671 375 Bitter Bitch Imperial IPA 980 0.082 138
## Style Ounces Name.y City
## 1671 American Double / Imperial IPA 12 Astoria Brewing Company Astoria
## State
## 1671 OR# create histogram of the number of breweries in each state for question #1
# Colorado has the most breweries followed by California
BreweriesData %>% ggplot(aes(x=fct_infreq(State))) +
geom_bar(stat = "count") +
labs(title="Number of Breweries in each State",
y="Count",
x="State") +
theme(axis.text.x = element_text(size = rel(0.8), angle = 90))
# Show a map of the US to show how many breweries are in each state with plotly for question #1
# The coastal states tend to have more breweries than inland states. States know to have high populations tend to have more breweries.
g = list(scope = 'usa')
fig = plot_geo(BreweriesData, locationmode = 'USA-states') %>%
add_trace(
colors = 'purples'
) %>%
colorbar(title = "Number of breweries in each state") %>%
layout(geo = g)## No scattergeo mode specifed:
## Setting the mode to markers
## Read more about this attribute -> https://plotly.com/r/reference/#scatter-mode## Warning: Didn't find a colorbar to modify.# Creates a map of the US to show count of how many breweries are in each state;
states_map <- map_data("state")
map_data1 = BreweriesData %>% count(State)
map_data1$State = state.name[match(str_squish(map_data1$State), state.abb)]
map_data1$State = tolower(map_data1$State)
ggplot(map_data1, aes(map_id = State)) +
geom_map(aes(fill = n), map = states_map) +
expand_limits(x = states_map$long, y = states_map$lat) +
labs(title = "Count of Breweries in the US")+
ggthemes::theme_map() +
scico::scale_fill_scico(palette = "berlin")
# Compute the median alcohol content and international bitterness unit for each state then plot with a bar chart for question number 4
# States with a higher number of breweries tend to be towards the middle of the rankings for ABV and IBU.
# D.C has the highest median ABV and Maine has the highest IBU
stateMedianABV = mergedBeerData %>% filter(!is.na(ABV)) %>% group_by(State) %>% summarise(Median = median(ABV)) %>% arrange(desc(Median))
stateMedianIBU = mergedBeerData %>% filter(!is.na(IBU)) %>% group_by(State) %>% summarise(Median = median(IBU)) %>% arrange(desc(Median))
stateNumberOfBeersABV = mergedBeerData %>% filter(!is.na(ABV)) %>% group_by(State) %>% tally()
stateNumberOfBeersIBU = mergedBeerData %>% filter(!is.na(IBU)) %>% group_by(State) %>% tally()
stateMedianABV = merge(stateMedianABV, stateNumberOfBeersABV, by = "State")
stateMedianIBU = merge(stateMedianIBU, stateNumberOfBeersIBU, by = "State")
stateMedianABV## State Median n
## 1 AK 0.0555 24
## 2 AL 0.0600 10
## 3 AR 0.0520 5
## 4 AZ 0.0550 35
## 5 CA 0.0575 158
## 6 CO 0.0600 213
## 7 CT 0.0600 25
## 8 DC 0.0625 8
## 9 DE 0.0550 1
## 10 FL 0.0585 54
## 11 GA 0.0550 16
## 12 HI 0.0545 22
## 13 IA 0.0560 27
## 14 ID 0.0555 28
## 15 IL 0.0585 82
## 16 IN 0.0590 126
## 17 KS 0.0500 20
## 18 KY 0.0625 18
## 19 LA 0.0520 19
## 20 MA 0.0550 73
## 21 MD 0.0600 19
## 22 ME 0.0520 26
## 23 MI 0.0610 143
## 24 MN 0.0555 54
## 25 MO 0.0520 39
## 26 MS 0.0580 9
## 27 MT 0.0550 29
## 28 NC 0.0570 49
## 29 ND 0.0500 3
## 30 NE 0.0550 19
## 31 NH 0.0550 8
## 32 NJ 0.0460 8
## 33 NM 0.0620 13
## 34 NV 0.0600 10
## 35 NY 0.0550 66
## 36 OH 0.0590 48
## 37 OK 0.0600 17
## 38 OR 0.0580 95
## 39 PA 0.0565 96
## 40 RI 0.0565 24
## 41 SC 0.0550 14
## 42 SD 0.0600 7
## 43 TN 0.0570 6
## 44 TX 0.0560 112
## 45 UT 0.0400 23
## 46 VA 0.0560 36
## 47 VT 0.0550 25
## 48 WA 0.0550 65
## 49 WI 0.0520 68
## 50 WV 0.0620 2
## 51 WY 0.0520 13stateMedianIBU## State Median n
## 1 AK 46.0 17
## 2 AL 43.0 9
## 3 AR 39.0 1
## 4 AZ 20.5 18
## 5 CA 42.0 111
## 6 CO 38.0 119
## 7 CT 40.0 5
## 8 DC 47.5 4
## 9 DE 52.0 1
## 10 FL 57.5 36
## 11 GA 55.0 7
## 12 HI 23.5 14
## 13 IA 25.5 22
## 14 ID 35.0 15
## 15 IL 30.0 33
## 16 IN 33.0 83
## 17 KS 21.0 16
## 18 KY 31.5 12
## 19 LA 31.5 10
## 20 MA 35.0 42
## 21 MD 30.0 9
## 22 ME 61.0 7
## 23 MI 35.0 38
## 24 MN 44.0 45
## 25 MO 24.0 29
## 26 MS 45.0 9
## 27 MT 40.0 13
## 28 NC 31.0 26
## 29 ND 32.0 3
## 30 NE 29.0 7
## 31 NH 48.5 2
## 32 NJ 34.5 8
## 33 NM 51.0 6
## 34 NV 41.0 8
## 35 NY 46.5 40
## 36 OH 40.0 32
## 37 OK 35.0 9
## 38 OR 40.0 60
## 39 PA 30.0 47
## 40 RI 24.0 17
## 41 SC 30.0 5
## 42 TN 37.0 5
## 43 TX 34.0 82
## 44 UT 33.0 10
## 45 VA 42.0 31
## 46 VT 30.0 15
## 47 WA 37.0 40
## 48 WI 24.0 31
## 49 WV 57.5 2
## 50 WY 27.0 10stateMedianABV %>% ggplot(aes(x = reorder(State, -Median), y = Median)) +
geom_bar(stat = "identity", aes(fill = n)) +
scico::scale_fill_scico(palette = "lajolla") +
theme(axis.text.x = element_text(size = rel(0.8), angle = 90)) +
labs(title="Median ABV by State",
y="Median ABV",
x="State",
fill = "# Beers")
stateMedianIBU %>% ggplot(aes(x = reorder(State, -Median), y = Median)) +
geom_bar(stat = "identity", aes(fill = n)) +
scico::scale_fill_scico(palette = "lajolla") +
theme(axis.text.x = element_text(size = rel(0.8), angle = 90)) +
labs(title="Median IBU by State",
y="Median IBU",
x="State",
fill = "# Beers")
# Summary statistics for ABV variable for question #6
# The mean ABV is higher than the median ABV. ABV ranges from 1 to 12.8 percent
summary(mergedBeerData %>% filter(!is.na(ABV)))## Brewery_id Name.x Beer_ID ABV
## Min. : 1.00 Length:2110 Min. : 4.0 Min. :0.00100
## 1st Qu.: 94.25 Class :character 1st Qu.: 951.2 1st Qu.:0.05000
## Median :210.00 Mode :character Median :1538.5 Median :0.05600
## Mean :232.21 Mean :1499.0 Mean :0.05985
## 3rd Qu.:366.00 3rd Qu.:2107.8 3rd Qu.:0.06800
## Max. :558.00 Max. :2692.0 Max. :0.12800
##
## IBU Style Ounces
## Min. : 4.00 American IPA : 377 Min. : 8.40
## 1st Qu.: 22.00 American Pale Ale (APA) : 205 1st Qu.:12.00
## Median : 35.00 American Amber / Red Ale : 110 Median :12.00
## Mean : 42.67 American Blonde Ale : 94 Mean :13.61
## 3rd Qu.: 62.00 American Double / Imperial IPA: 91 3rd Qu.:16.00
## Max. :138.00 American Pale Wheat Ale : 69 Max. :32.00
## NA's :889 (Other) :1164
## Name.y City State
## Length:2110 Length:2110 CO : 213
## Class :character Class :character CA : 158
## Mode :character Mode :character MI : 143
## IN : 126
## TX : 112
## PA : 96
## (Other):1262# Boxplot of ABV for question #6
# This shows a right skew of the ABV data
scatterPlotABV = ggplot(data = mergedBeerData %>% filter(!is.na(ABV)), aes(x=ABV)) +
geom_boxplot() +
ylim(-1,1) +
labs(title = "ABV Distrobution", x = "ABV") +
theme(axis.text.y = element_blank(), axis.ticks.y = element_blank())
plot(scatterPlotABV)
ggplotly(scatterPlotABV)## Warning: Continuous y aesthetic -- did you forget aes(group=...)?# Distribution of the ABV variable for question #
# This shows a right skew of the ABV data
barPlotABV <- ggplot(data = mergedBeerData %>% filter(!is.na(ABV)), aes(x=ABV)) +
geom_bar(stat = "count") +
labs(title="Distribution of ABV",
y="Count",
x="ABV")
ggplotly(barPlotABV)# Scatter plot between IBU and ABV for question #7
# There is a plausible relationship between the ABV and IBU.
# While ABV values are low we see a general trend of low IBUs, and on the flipside, when ABV values are high, we see a corresponding trend of high IBUs.
# Naturally, there are outliers to this data, which are very likely contributing to the secondary curve in the graph and as previously mentioned, but generally this is a very plausible relationship.
scatterPlotIBUvsABV = mergedBeerData %>% filter(!is.na(ABV) & !is.na(IBU)) %>% ggplot(aes(x=ABV, y=IBU)) +
geom_point(position = "jitter") +
geom_smooth(method = "loess", se = F) +
labs(title = "Relationship between ABV and IBU",
y = "IBU",
x = "ABV")
#plot(scatterPlotIBUvsABV)
#ggplotly(scatterPlotIBUvsABV)
#ggMarginal(scatterPlotIBUvsABV, type = "histogram")
#ggMarginal(scatterPlotIBUvsABV, type = "boxplot")
ggMarginal(scatterPlotIBUvsABV)## `geom_smooth()` using formula 'y ~ x'
## `geom_smooth()` using formula 'y ~ x'
## `geom_smooth()` using formula 'y ~ x'
# Get list of all unique styles of beers and the number of beers of each style
# For question/item 8 and 9
# Only keep beers with a Style, ABV and IBU
uniqueStyles = mergedBeerData %>% filter(!is.na(Style))
# Create dataframe that contains every unique style and how many beers have that style
uniqueStyles = uniqueStyles %>% group_by(Style) %>% tally()
uniqueStyles## # A tibble: 100 × 2
## Style n
## <fct> <int>
## 1 "" 5
## 2 "Abbey Single Ale" 2
## 3 "Altbier" 12
## 4 "American Adjunct Lager" 12
## 5 "American Amber / Red Ale" 118
## 6 "American Amber / Red Lager" 25
## 7 "American Barleywine" 3
## 8 "American Black Ale" 32
## 9 "American Blonde Ale" 97
## 10 "American Brown Ale" 65
## # … with 90 more rows# Prepare data for knn modeling to predict style based off of ABV and IBU for question #8
# We can see that a K value of 6 yields the best accuracy at % 86.15960
# Only keep beers with a Style, ABV and IBU
AbvIbuBeer = mergedBeerData %>% filter(!is.na(ABV) & !is.na(IBU) & !is.na(Style))
# Set the style column to numeric to more easily manipulate the values
AbvIbuBeer$Style = as.character(AbvIbuBeer$Style)
# Keep only beers with a style containing string "IPA" or "Ale"
AbvIbuBeer = AbvIbuBeer[str_detect(AbvIbuBeer$Style, "IPA|Ale"),]
# If a syle doesn't contain the "IPA" but does contain "Ale" then change style to "Other"
AbvIbuBeer$Style[AbvIbuBeer$Style != grepl("IPA", AbvIbuBeer$Style, fixed = TRUE) & grepl("Ale", AbvIbuBeer$Style, fixed = TRUE)] = "Other"
# Figure out how to change any style containing "IPA" to type "IPA"
AbvIbuBeer$Style[grepl("IPA", AbvIbuBeer$Style, fixed = TRUE)] = "IPA"
# Only keep beers with style 'IPA' or 'Other'
AbvIbuBeer = AbvIbuBeer %>% filter(Style == "IPA" | Style == "Other")
AbvIbuBeer$Style = as.factor(AbvIbuBeer$Style)
# Drop all levels except for 'IPA' and 'Other'
AbvIbuBeer$Style = droplevels(AbvIbuBeer$Style)
table(AbvIbuBeer$Style)##
## IPA Other
## 340 462# Model relationship between ABV and IBU with knn
maxKvalue = 100
accuracyVector = c(maxKvalue)
for(i in 1:maxKvalue){
classifications = knn.cv(AbvIbuBeer[,c(4,5)], AbvIbuBeer$Style, k=i, prob = TRUE)
accuracyVector[i] = confusionMatrix(table(classifications, AbvIbuBeer$Style))$overall[1]
}
higestAccuracyKValue = which.max(accuracyVector)
higestAccuracyKValue## [1] 6accuracyVector## [1] 0.8004988 0.8092269 0.8304239 0.8366584 0.8466334 0.8566085 0.8553616
## [8] 0.8566085 0.8491272 0.8541147 0.8528678 0.8516209 0.8491272 0.8478803
## [15] 0.8478803 0.8441397 0.8441397 0.8466334 0.8553616 0.8553616 0.8553616
## [22] 0.8553616 0.8553616 0.8553616 0.8553616 0.8553616 0.8553616 0.8553616
## [29] 0.8553616 0.8553616 0.8553616 0.8516209 0.8528678 0.8503741 0.8503741
## [36] 0.8478803 0.8541147 0.8541147 0.8541147 0.8541147 0.8541147 0.8541147
## [43] 0.8541147 0.8541147 0.8541147 0.8541147 0.8541147 0.8541147 0.8541147
## [50] 0.8541147 0.8541147 0.8541147 0.8541147 0.8541147 0.8528678 0.8528678
## [57] 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678
## [64] 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678
## [71] 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678
## [78] 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678
## [85] 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678
## [92] 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678 0.8528678
## [99] 0.8528678 0.8528678# Plot Knn Accuracy and IBU/ABV by Style for question #8
plot(seq(1, maxKvalue, 1), accuracyVector, type = "l", xlab = "K value", ylab = "accuracy", main = "accuracy for k values")
AbvIbuBeer %>% ggplot(aes(x = ABV, y = IBU, color = Style)) +
geom_jitter() +
labs(title="IBU vs ABV for IPA's and Other Ales")
# Question #9
# The mean beer. Find the mean ABV, IBU, most common number of ounces, and most common style of beer
# Name: "Average Beer"
# Calculate the mean ABV/IBU
ABVBeer = mergedBeerData %>% filter(!is.na(ABV))
IBUBeer = mergedBeerData %>% filter(!is.na(IBU))
# with a count of 384 the American IPA is the most common style of beer
# most common ounces is 12
"Mean ABV:"## [1] "Mean ABV:"mean(ABVBeer$ABV)## [1] 0.05985071"Mean IBU:"## [1] "Mean IBU:"mean(IBUBeer$IBU)## [1] 42.67322